The DECIMAL function converts a text representation of a number in a given base into a decimal number.
Formula in cell D3:
Excel Function Syntax
Required. The text argument must be less than 256 characters. The Text argument can be alpha-numeric characters that are valid for the radix. Excel supports a Text argument greater than or equal to 0 and less than 2^53.
Required. Radix must be greater than or equal to 2 (binary, or base 2) and less than or equal to 36 (base 36).
A radix greater than 10 use the numeric values 0-9 and the letters A-Z as needed. For example, base 16 (hexadecimal) uses 0-9 and A-F, and base 36 uses 0-9 and A-Z.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Math and trigonometry'
The DECIMAL function function is one of many functions in the 'Math and trigonometry' category.