# BIN2OCT

BIN2OCT(number, places)

Returns the number converted from binary to octal.

 number The binary number you want to convert. places The number of characters to use.

 REMARKS
 * If "number" contains more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits.* If "number" contains 10 characters then the most significant bit (i.e. the first number) represents the sign bit (i.e. either positive or negative).* If "number" contains more than 10 characters (10 bits), then #NUM! is returned.* If "number" < 0 then two's-complement notation is used to represent the number.* If "number" < 0, then "places" is ignored and a 10-character octal number is returned.* If "number" is not a valid binary number, then #NUM! is returned.* If "places" is less than the number of characters needed, then #NUM! is returned.* If "places" is left blank, then the minimum number of characters necessary.* If "places" is not an integer, it is truncated.* If "places" is not numeric, then #VALUE! is returned.* If "places" < 0, then #NUM! is returned.* The "places" is useful for padding the return value with leading 0s.* You can use the BIN2DEC function to convert a number from binary to decimal.* You can use the BIN2HEX function to convert a number from binary to hexadecimal.* You can use the OCT2BIN function to convert a number from octal to binary.* The equivalent VBA function is VBA.OCT* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =BIN2OCT(1) = 1 2 =BIN2OCT(10) = 2 3 =BIN2OCT(100) = 4 4 =BIN2OCT(111) = 7 5 =BIN2OCT(10001) = 21 6 =BIN2OCT(100000000) = 400 7 =BIN2OCT(1100000000) = 7777777400 8 =BIN2OCT(1111111111) = 7777777777 9 =BIN2OCT(1111111110) = 7777777776 10 =BIN2OCT(1111111101) = 7777777775 11 =BIN2OCT(1111111111) = 7777777777 12 =BIN2OCT(1001, 3) = 011 13 =BIN2OCT(1100100) = 144 14 =BIN2OCT(-10) = #NUM! 15 =BIN2OCT(123456789012) = #NUM! 16 =BIN2OCT("some text") = #NUM!
{"found_math": false, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 0, "img_math": 0, "codecogs_latex": 0, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0, "katex": 0, "math-container": 0, "wp-katex-eq": 0, "align": 0, "equation": 0, "x-ck12": 0, "texerror": 0, "url": "https://bettersolutions.com/excel/functions/bin2oct-function.htm", "fetch_time": 1725985537000000000, "content_mime_type": "text/html", "warc_filename": "crawl-data/CC-MAIN-2024-38/segments/1725700651303.70/warc/CC-MAIN-20240910161250-20240910191250-00565.warc.gz", "warc_record_offset": 115179946, "warc_record_length": 6340, "token_count": 634, "char_count": 2037, "score": 3.53125, "int_score": 4, "crawl": "CC-MAIN-2024-38", "snapshot_type": "latest", "language": "en", "language_score": 0.7508400082588196, "file_path": "/sailhome/yjruan/project/latent-lm/data/processed/finemath-4plus/finemath-4plus/train-00060-of-00064.parquet"}