BIN2OCT function
BIN2OCT converts a binary number to an octal number.
Syntax
BIN2OCT(number,[places])
Number is a binary number. The number can have a maximum of 10 places (bits). The most significant bit is the sign bit. Negative numbers are entered as two's complement.
Places means the number of places to be output.
Example
=BIN2OCT(1100100,4) returns 0144.