DEC2OCT

Formulas / DEC2OCT
Convert decimal numbers to octal numbers.
==DEC2OCT(number,[places])
  • number - required decimal number to octal conversion
  • places - [OPTIONAL] number of places to return

Examples

  • =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.


Summary

The DEC2OCT function in Sourcetable is a useful tool for quickly converting decimal numbers to octal equivalents.

  • The DEC2OCT function takes two arguments: number (required) and places (optional).
  • The number argument is the decimal number to convert to octal, and the places argument pads the resulting octal number with zeros to the specified number of digits.

Frequently Asked Questions

What is the DEC2OCT function?
The DEC2OCT function is a mathematical function that takes a decimal number and converts it to an octal format.
What is the argument of the DEC2OCT function?
The argument of the DEC2OCT function is a decimal number.
What does the DEC2OCT function return?
The DEC2OCT function returns a 30-bit octal number.
What are some examples of using DEC2OCT?
Here are some examples of using DEC2OCT:
  • Convert the decimal number 10 to octal: DEC2OCT(10) = 12
  • Convert the decimal number 32 to octal: DEC2OCT(32) = 40
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV