## 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 68

## What is the purpose of **Decimal** function?

**Decimal**

It **Converts a text **representation of a number in a given base into a **decimal number**.

## What is the Return value of **Decimal** function?

**Decimal**

It returns a number.

## How many arguments does **Decimal** function have?

**Decimal**

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?

**Decimal**

This function is available for all excel **versions **(2003-2019)

## Errors in **Decimal** function

**Decimal**

**Decimal related functions :**

- BASE function
- ROUND function
- RANDOM function
- AVERAGE function