Excel BIN2OCT function

Function              BIN2OCT

Description        Excel BIN2OCT function binary number to octal number system.

Syntax                  BIN2OCT(number, [places])

Number    Required. The binary number to convert. Number cannot contain more than 10 characters (10 bits).

Places    Optional. The number of characters to use. If places is omitted, BIN2OCT uses the minimum number of characters necessary.

Example:

Usage Notes:

• If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2OCT returns the #NUM! error value.
• If number is negative, BIN2OCT ignores places and returns a 10-character hexadecimal number.
• It returns the #NUM! error value if BIN2OCT requires more than places characters.
• It is truncated when places is not an integer.
• Returns the #VALUE! error value when places is nonnumeric.
• BIN2OCT returns the #NUM! error value when places is negative.