Excel CONVERT Function

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

  1. Click on an empty cell (like F5).
empty cell in excel

2. 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 Engineering category.

5. Select CONVERT function.

6. Then select ok.

excel CONVERT function

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.

How to use CONVERT function in excel

Examples of CONVERT function in Excel

Example 1:

How to use CONVERT function in excel

You can see examples of CONVERT function below:

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

It converts a number from one measurement system to another.

Return value of CONVERT function

It returns a number.

Arguments of CONVERT function

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

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

Errors in CONVERT function

CONVERT related functions 

Leave a Reply

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