What is Decimal function in Excel?
The Decimal function is one of the math functions of Excel.
It Converts a text representation of a number in a given base into a decimal number.
We can find this function in Math & trig category of insert function Tab.
How to use Decimal function in excel
- Click on an empty cell (like F5 )
- Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select Decimal function
6. Then select ok
7. In the function Arguments Tab you will see Decimal function
8. In the number box you must enter a number (for example 56)
9. Radix is the base number you want to convert into (for example 10)
10. If you enter (56,10) result will be 56
11. If you enter (56,7) result will be 41
12. If you enter (11,2) result will be 3
13. You will see results in the formula result section
Examples of Decimal function in Excel
Example 1:
How to use DECIMAL function in excel
You can see examples of DECIMAL function below:
decimal(A2,B2) ----->>>>answer is 56
decimal(A3,B3) ----->>>>answer is 2
decimal(A4,B4) ----->>>>answer is 3
decimal(A5,B5) ----->>>>answer is 81
decimal(A6,B6) ----->>>>answer is 68What is the purpose of Decimal function?
It Converts a text representation of a number in a given base into a decimal number.
What is the Return value of Decimal function?
It returns a number.
How many arguments does Decimal function have?
This function has just 2 Argument.
The argument of Decimal function is number.
In the number box you must enter a number (for example 56).
Radix is the base number you want to convert into (for example 10).
The argument of Decimal function is required and not optional.
DECIMAL(number) = number
Which version of excel supports Decimal function?
This function is available for all excel versions (2003-2019)
Errors in Decimal function
Decimal related functions :
- BASE function
- ROUND function
- RANDOM function
- AVERAGE function
