Excel DECIMAL Function

★ 20 minutes read

Just as it is with using other different functions in Excel, there are also ways to use the DECIMAl function. This post will guide you on how to use the Excel DECIMAL function in Excel with syntax.

Excel DECIMAL Function

Formula

=DECIMAL (number, radix)

Explanation

The parameters of the function are:

number – A string of alphanumeric characters you want to convert;
radix – An integer within the range [2, 36] corresponding with the provided base.

Example 1

 

 

Figure 1: Excel DECIMAL function

The Excel DECIMAL function receives an alpha-numeric integer/number in a specific base and returns its corresponding decimal value.
Listed below are some Base values and their corresponding alpha-numeric characters

Common Errors:

#NUM! – Occurs if:
The provided radix is less than 2 or greater than 36 or the provided text argument is unrecognized as a number in the specific radix.

#VALUE! – Occurs if:
The provided text argument is above 255 characters long or the provided base is non-numeric.

Notes

The input string must contain only valid alpha-numeric characters that correspond to the base of the integer to be converted.
The Decimal function is not available in the earlier versions of Excel before 2013.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar