Decimal function in Excel

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

  1. Click on an empty cell (like F5 )
empty cell in excel
  1. Click on the fx icon (or press shift+F3)
fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select Decimal function

6. Then select ok

math and trig function category in excel

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

 Decimal function in excel

11. If you enter (56,7) result will be 41

 excel Decimal function

12. If you enter (11,2) result will be 3

How to use Decimal function in excel

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:

Examples of Decimal function in Excel
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  68

What 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 :

Leave a Reply

Your email address will not be published. Required fields are marked *