DEC2OCT Function

how to use dec2oct function in excel


You can convert decimal numbers into octal numbers
Octal numbers contain 0 to 7 values

DEC2OCT Function has a limit of eight times "9"
If you write nine times "9" characters it will return #NUM error

Syntax


=DEC2OCT(number,[place])

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 decimal number and convert it into octal numbers.
We have written a formula  

=DEC2OCT(D4,4) which will convert the decimal number into octal numbers

On the right side, if you write eight times "9" it will return "575360377"
If you write nine times "9" it will return #NUM error because it is the limit of the Function

Usage

To convert an Decimal number into a Octal number

Returns



Octal number

No comments:

Post a Comment