EXCEL DECIMAL FUNCTION
Excel DECIMAL Function Introduction
The Decimal function in Excel transforms a text representation of a number in a given base to a decimal value. Due to the fact that the Decimal function was just introduced in Excel 2013, it is not available in previous versions of Excel.
Description of Excel DECIMAL Function
Syntax :
=DECIMAL ( text, radix )
Parameters :
- The following are the arguments:
Text :
- The text representation of the number to be converted (must be less than 256 characters long).
Radix :
- The given number’s base (radix) (must be an integer between 2 and 36).
Step By Step Guide of DECIMAL Function
Example :
The spreadsheet below contains four instances of the Excel Decimal Function: The given text parameters in the following spreadsheet are all contained in quotation marks, as is necessary for Excel text strings; in cell A5, the supplied text “2000” is not a valid representation of a base 2 integer, and hence the Decimal function returns the #NUM! error.
Key Points
- #NUM! – This error occurs if either: the provided radix is 2 or greater than 36; or the supplied text parameter is not recognised as a number in the chosen base (radix).
- #VALUE! – Occurs if any of the following conditions is met: the provided text argument is longer than 255 characters; or the specified radix 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
