Excel OCT2BIN function

Function              OCT2BIN

Description        Excel OCT2BIN function converts Octal number system to Binary number system.

Syntax                  OCT2BIN(number, [places])

Number               is the octal number and it should not be more than 10 characters. Negative numbers are returned with two’s complement method.

[places]                                Optional. Which specifies the number of characters that you want the returned binary number to have. If omitted returns the least number of characters required to represent the number.

Example:

Usage Notes:

• If number is negative, OCT2BIN ignores places and returns a 10-character binary number.
• Negative number, it cannot be less than 7777777000, and positive number cannot be greater than 777.
• OCT2BIN returns the #NUM! error value when number is not a valid octal number.
• It returns the #NUM! error value when OCT2BIN requires more than places characters.
• If places is non-integer, it is truncated.
• OCT2BIN returns the #VALUE! error value when places is nonnumeric.
• OCT2BIN returns the #NUM! error value when places is negative.