How to use BIN2OCT Function in Excel

The Microsoft Excel BIN2OCT function converts a binary number to an octal number. The BIN2OCT function is a built-in function in Excel that is categorized as an Engineering Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the BIN2OCT function can be entered as part of a formula in a cell of a worksheet.

Syntax: BIN2OCT(number, [places])

The BIN2OCT function syntax has the following arguments:

  • Number    Required. The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two’s-complement notation.
  • Places    Optional. The number of characters to use. If places is omitted, BIN2OCT uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

Example: Let’s look at some Excel BIN2OCT function examples and explore how to use the BIN2OCT function as a worksheet function in Microsoft Excel:

Syntax:  =BIN2OCT(A2)


Based on the Excel spreadsheet above, the following BIN2OCT examples would return:

Syntax: =BIN2OCT(A3)
Result: 24

Syntax: =BIN2OCT(A4)
Result: 4

Syntax: =BIN2OCT(A5)
Result: 7

Syntax: =BIN2OCT(A6)
Result: 2

Syntax: =BIN2OCT(A7)
Result: 35

Syntax: =BIN2OCT(A8)
Result: 144

Syntax: =BIN2OCT(A9)
Result: #NUM!

Syntax: =BIN2OCT(A10)
Result: #NUM!

Syntax: =BIN2OCT(A11,B11)
Result: 0077

Syntax: =BIN2OCT(A12,B12)
Result: 00077

Syntax: =BIN2OCT(A13,B13)
Result: 000077

Syntax: =BIN2OCT(A14,B14)
Result: 011

Syntax: =BIN2OCT(A15,B15)
Result: #NUM!


  1. Numbers can be given as argument to the function directly without quotes or cell reference in excel.
  2. The function doesn’t consider the [places] number in case of a negative decimal number.
  3. If the input [places] number is not an integer, it is truncated by the function.
  4. The input number must be a valid binary numeric number.
  5. If the input number has less than 10 digits, the function takes 0s to the left of the number to complete its 10 character binary value.
  6. The function returns the #VALUE! Error
    1. If the input number is text or non-numeric.
    2. If the input [places] number is text or non-numeric.
  7. The function returns the #NUM! Error
    1. If the input characters exceed by 10 digits.
    2. If the input number is not a valid binary expression.
    3. If the input number have fraction part or decimal part for example: 010111.101

Add a Comment

Your email address will not be published. Required fields are marked *