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.609Purpose 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)
