## What is CONVERT Function in Excel?

The **CONVERT **function is one of the ** Engineering** functions of Excel.

It converts a **number **from one **measurement system** to another.

We can find this function in **Engineering **category of the insert function Tab.

## How to use CONVERT function in excel

- Click on an
**empty cell**(like F5).

2. Click on the** fx icon** (or press** shift+F3**).

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

4. Select **Engineering **category.

5. Select **CONVERT **function.

6. Then select **ok**.

7. In function arguments Tab you will see **CONVERT function**.

8. Number section is the **value **in from **units **to convert.

9. From_unit section is** the units** for a **number**.

10. To_unit section is **the units** for the **result**.

11. You will see the **results **in the formula result section.

## Examples of CONVERT function in Excel

**Example 1:**

**How to use CONVERT function in** **excel**

You can see examples of **CONVERT** function below:

```
convert(A2,B2,C2) ----->>>>answer is 2.54
convert(A3,B3,C3) ----->>>>answer is 12
convert(A4,B4,C4) ----->>>>answer is 36
convert(A5,B5,C5) ----->>>>answer is 1.609
```

## Purpose of **CONVERT** function

**CONVERT**

It converts a **number **from one **measurement system** to another.

## Return value of **CONVERT** function

**CONVERT**

It returns a number.

## Arguments of **CONVERT** function

**CONVERT**

This function has just **3 **Argument.

The **argument **of CONVERT function is **number**.

Number section is the **value **in from **units **to convert.

From_unit section is** the units** for a **number**.

To_unit section is **the units** for the **result**.

The argument of CONVERT function is **required **and not optional.

```
CONVERT(number) = number
```

## Version of excel supports **CONVERT** function

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

## Errors in **CONVERT** function

**CONVERT**