Menu
EXCEL DEC2OCT FUNCTION
Excel DEC2OCT Function Introduction
The most often used number systems in engineering and computing are hexadecimal (base 16), decimal (base 10), octal (base 8), and binary (base 2). As a result, Excel has functions for converting numeric numbers to and from each of these systems. The Dec2Oct function in Excel transforms a decimal value to an octal (Base 8) number.
Description of Excel DEC2OCT Function
Syntax :
=DEC2OCT ( number, [places] )
Parameters :
- In this case, the function parameters are as follows:
Number :
- The decimal number to be converted to an octal number.
Places :
- An optional parameter that determines the amount of characters in the returned octal number.
- If this value is more than zero, the octal number will be padded with leading zeros.
- If [places] is not specified, the returned octal has the fewest number of places.
Step By Step Guide of DEC2OCT Function
Example :
The spreadsheets below illustrate five different uses for the Excel Dec2Oct function. It’s worth noting that the negative octal number in cell A4 in the above example spreadsheet is represented using two’s complement notation.
Key Points
- #NUM! – Occurs if the given number argument is either -536,870,912 or more than 536,870,911;
The generated octal number requires more places than the supplied [places] argument specifies; the supplied [places] parameter is 0 or greater than 10. - #VALUE! – Occurs if either the supplied number argument or the supplied [places] argument is non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
