==DEC2OCT(number,[places])
=DEC2OCT(58, 3)
The DEC2OCT function in Sourcetable is used to convert a decimal number to an octal number. This is done by specifying the decimal number along with the desired number of octal digits to the right of the decimal point. For example this formula will convert decimal 58 to octal and return 70.
=DEC2OCT(58, 0)
The DEC2OCT function can also be used to convert a decimal number to an octal number with no decimal places. For example, this formula will convert decimal 58 to octal and return 72.
=DEC2OCT(58, 5)
The DEC2OCT function can also be used to convert a decimal number to an octal number with multiple decimal places. For example, this formula will convert decimal 58 to octal and return 0.070.
=DEC2OCT(-58, 5)
The DEC2OCT function is also capable of converting negative decimal numbers to octal numbers. For example, this formula will convert decimal -58 to octal and return -0.070.
The DEC2OCT function in Sourcetable is a useful tool for quickly converting decimal numbers to octal equivalents.