In this post, you will learn about the Decimal function in Excel and how to use it with-in an excel spreadsheet.
Syntax
=DECIMAL(number, radix)
The Decimal Function Syntax has two arguments
number – Holds the alphanumeric values.
radix – A number between the range 2-36 which hold the base/radix for the number to be converted.
Note:
- Both the number and the radix argument is a required factor.
- The word Alphanumeric represents the form that uses or is made up of both numbers and alphabets.
How does the Decimal Function work in Excel?
When the syntax accepts the values entered, the function takes place and converts the number/character into decimal numbers according to the radix.
- Open a document with the necessary content or enter the numbers to be converted.
- In a new cell enter the syntax and highlight the necessary arguments to include them in the function.
- Press enter to display the answer.
- Use the fill handle to apply the function to the remaining data.
The alphanumeric value you are using in the Decimal function must be a valid character with the given radix.
Important points:
The following are the most commonly used radix values.
| Radix/ base | Radix | Range of Alphanumeric values |
|---|---|---|
| Binary | 2 | 0 – 1 |
| Octal | 8 | 0 – 7 |
| Decimal | 10 | 0 – 9 |
| Hexa decimal | 16 | 0 – 9 and A – F |
| Hexatri decimal | 36 | 0 – 9 and A – Z |
- Only the values between the above-assigned ranges for their respective radix values will be accepted by the syntax.
- The radix argument is a non-case sensitive.
- The function returns #NUM! due to one of the following reasons,
- The radix value is less than 2 or greater than 36.
- The value in the number argument is not recognized by the syntax (eg : =,+,<,>,””,….).
- The number of characters in the number argument is greater than 225.
- And the function returns #VALUE! due to one of the following reasons,
- The radix argument exceeds the character limit of 225.
- The radix argument contains a non-numeric value.
