As we know, decimals are one of the types of numbers, which has a whole number and the fractional part separated by a decimal point. For instance, 3.45, where 3 is the whole number, and .45 is the fraction part. The dot refers to the decimal point. In Excel, the DECIMAL function helps to convert the text representation of digits of a given base to decimal numbers (base =10).
Let’s see how to use Excel Decimal Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:
What is the DECIMAL Function?
DECIMAL is one of the built-in functions in Microsoft Excel. It comes under Math functions. We can use this function in our spreadsheet whenever we want to convert an alpha-numeric number into a decimal value. Generally, alpha-numeric values are made up of 26 letters of the alphabet (A through Z) and the digits 0 through 9.
- This is the basic syntax of the Excel DECIMAL Function.
- number – The input number which contains the alpha-numeric value.
- radix – The radix or base number to convert the input number based on it.
- This Decimal function converts an alpha-numeric number into a decimal value.
4) Return Value
- It returns the decimal number as output.
1) The input string length must be less than or equal to 255 characters.
2) If any of the arguments is an invalid value, it returns the #NUM! or #VALUE Error.
What Will DECIMAL Function Do?
As we said earlier, the DECIMAL function will convert an alpha-numeric number into a decimal value. This function is categorized as “Math” in Excel. Let’s see an example scenario to make you understand it easily.
Step 1: For example, we have a set of integers with different bases, and we need to convert them into decimal values based on the given radix using the DECIMAL function.
Step 2: To get the decimal values, we need to apply the following formula in any cell where we want to get the result.
Step 3: Now, click on the Enter button to get the result.
Step 4: To fill down the remaining cells, you just drag down the first cell. It will auto-fill the remaining cells as shown in the below screenshot.
We hope that the given scenario helped you to understand the DECIMAL function. Move to the below section if you have any confusion related to the working nature of this function.
Here we will see how to apply the DECIMAL function in the spreadsheet with simple examples.
1) Suppose you want to convert a specific number into a decimal number, then you can directly apply it to the formula.
2) If we want to get the decimal value of the ZZ based on the radix “36“, we can apply the following formula in a cell where we want the result.
3) Hit the Enter button to get the result, as shown in the below image.
By doing so, you can quickly get the decimal value of the specific number with the help of the DECIMAL function.
Source of Errors in Excel
- If any of the arguments is an invalid value, it returns the #NUM! or #VALUE! Error.
To understand the usage of the DECIMAL function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: DECIMAL function, and What is Decimal?.
With the help of the given scenarios and examples, you can easily understand the purpose of the DECIMAL function in Excel and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your feedback in the below comment section. Thanks for visiting AawExcel. Keep Learning!!
If you want to know what people think about this DECIMAL Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel DECIMAL function. Here, we have provided the link to Quora’s official website.
The following video will show you how to use the Excel DECIMAL function in the spreadsheet with proper examples.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?