BIN2OCT Function

how to use bin2oct function in excel

You can convert binary numbers into octal numbers
The binary numbers contain only 0 and 1 values
Octal numbers contain 0 to 7 values

BIN2OCT Function has a limit of 10 characters
If you write more than 10 characters it will return #NUM error




Number: it is the number you want to convert into octal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.


Here we have taken an example of the binary number and convert it into octal numbers.
We have written a formula  

=BIN2OCT(C6,5) which will convert the binary number into octal and show result till 5 characters. No character place is fill by 0

On the right side, if you write 10 times "1" it will return 10 times "7"
If you write more than 10 characters it will return #NUM error


To convert a Binary number into an Octal number


Octal number

No comments:

Post a Comment