What is the Excel CONVERT Function?
The excel CONVERT function converts a number from one measurement system to another. There are measurement systems that can be handled by the CONVERT function, for example, convert mm to inches, convert meters to feet, convert minutes to hours, convert meters to miles and much more.
CONVERT Syntax
CONVERT(number,from_unit,to_unit)
number, required, the numeric value in from_units to convert
from_unit, required, the starting units for a number
to_unit, required, the ending units for the result
Usage Note:
- The number argument must be a number. Otherwise, Excel will try to convert to the number if unsuccessful the excel CONVERT function returns a #VALUE! Error.
- If from_unit or to_unit argument does not exist, the excel CONVERT function returns a #N/A! error.
- If from_unit or to_unit argument is in a different group, the excel CONVERT function returns a #N/A! error.
- from_unit and to_unit arguments are case-sensitive.
There are 13 group measurement systems. Please see Excel help menu for the detail.
How to Use CONVERT Function in Excel
Convert mm to inches in Excel
The Question
The latest MacBook Air has a thickness of 15.6mm. What is the thickness of the MacBook Air when calculated in Inches?
The Formula
=CONVERT(15.6,"mm","in")
number=15.6
from_unit= “mm”
to_unit= “in”
The Result
Convert meters to feet in Excel
The Question
Someone is 7 feet tall. Can he enter the house without problems with the house door has 2 meters high?
The Formula
=CONVERT(2,"m","ft")
number=2
from_unit= “m”
to_unit= “ft”
The Result
The door height is shorter than his height. To enter the house without problems, he must lower his body 😊
Convert Celcius to Fahrenheit in Excel
The Question
The water boils at a temperature of 100 degrees Celsius, what is 100 degrees Celsius in Fahrenheit units?
The Formula
=CONVERT(100,"C","F")
number=100
from_units= “C”
to_units= “F”
The Result
