You can convert octal numbers into binary numbers

The binary numbers contain only 0 and 1 values

Octal numbers contain 0 to 7 values

OCT2BIN Function has a limit of 777 octal numbers

If you write more than 777 characters it will return #NUM error

###
*Syntax of OCT2BIN Function*

=OCT2BIN(number,[places])

###
*Argument** of OCT2BIN Function*

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

###
*Behavior** of OCT2BIN Function*

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

We have written a formula

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

On the right side, if you write 777 it will return 9 times "1"

If you write 778 it will return #NUM error because in banary number it becomees 10 charecter

*Usage*

*of OCT2BIN Function*

To convert an Octal number into a Binary number

###
*Returns** of OCT2BIN Function*

Binary number

## No comments:

## Post a Comment