OCT2BIN Function in Excel – Convert Octal to Binary in Excel

OCT2BIN Function in Excel converts Octal number to Binary number.

Syntax of OCT2BIN Function in Excel (OCTAL TO BINARY FUNCTION IN EXCEL):

Where

• number – The octal number that is to be converted to binary.
• [places] –  An optional argument that specifies how many digits needs to be returned.

Example of OCT2BIN Function in Excel (OCTAL TO BINARY FUNCTION IN EXCEL):

Formula:

• In row number 2, OCT2BIN Function takes up [places] argument as 8 which returns the 8 digits with 4 preceding Zeros i.e. 00001111.

Result:

Note: #NUM! – Error occurs

• If the supplied number contains more than 10 character.
• If the resulting binary number exceeds more than 10 digits.
• If the supplied [places] argument is less than 0 and greater than 10.