DECIMAL

Formulas / DECIMAL
Convert a text representation of a number into a decimal number.
DECIMAL(text, radix)
  • text - required, string of alpha-numeric characters
  • radix - required, integer

Examples

  • =DECIMAL("FF",16)

    The DECIMAL function can be used to convert a number from one base to another. For example, this formula will return a decimal of 255.

  • =DECIMAL("1101",2)

    The DECIMAL function can also be used to convert binary numbers to decimal. For example, this formula will return a decimal of 13.

  • =DECIMAL(B5,C5)

    The DECIMAL function can be used in combination with other cell references. For example, this formula will convert the number in cell B5 to its decimal equivalent using the base in cell C5.

Summary

The DECIMAL function converts text representations of numbers into decimal numbers, requiring both the text and radix arguments. The radix must be an integer.

  • The DECIMAL function takes two arguments, a number and a radix (base). The number argument should be a number and the radix argument should be an integer between 2-36.
  • The DECIMAL function converts text strings in a known base to decimal numbers.


Frequently Asked Questions

What is the DECIMAL function?
The DECIMAL function is used to convert a text representation of a number into a decimal number.
What are the arguments of the DECIMAL function?
The DECIMAL function has two arguments:
  • text: required
  • radix: required
What is the purpose of the text argument?
The text argument is the text representation of the number that the DECIMAL function will convert.
What is the purpose of the radix argument?
The radix argument is the number base that the text argument is expressed in.

Related Functions

Sourcetable Logo

Work smarter

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

Drop CSV