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

*Syntax*

=BIN2OCT(number,[places])

*Argument*

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.

*Behavior*

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

*Usage*

To convert a Binary number into an Octal number

*Returns*

Octal number

## No comments:

## Post a Comment