CONVERT FUNCTION || Use of Excel CONVERT Function

Hello all, So here we are with one another Function that is used in Excel widely, that is CONVERT Function.CONVERT Function is used for converting different units of measurements.Like by using Convert Function we can convert meters into yards, miles into Kilometers etc.So, basically CONVERT Function is a unit conversion Function.

Image result for Convert function

What is CONVERT Function?

Convert Function comes under Engineering Function Category, which simply helps in converting data of one measurement unit into another unit.For Eg. Distance in miles can be converted into Kilometers, Mass in pounds can be converted into ounce mass etc.

SYNTAX For CONVERT Function:

=CONVERT(number,from_unit,to_unit)

ARGUMENTS:

  • number: The number you want to convert from one measurement unit to other, It’s a mandatory parameter.
  • from_unit: It is the initial unit for the numerical value.
  • to_unit: It is the unit you want your numeric value to convert into.

This is the table below, which specifies how you need to write “from_unit” and “to_unit” values in CONVERT Function as It accepts “from_unit” and “to_unit” values in quotation only.

Value Measurement Unit Measurement Type
“m” Meter Length/Distance
“mi” Mile Length/Distance
“Nmi” Nautical mile Length/Distance
“in” Inch Length/Distance
“ft” Foot Length/Distance
“yd” Yard Length/Distance
“ang” Angstrom Length/Distance
“pica” Pica Length/Distance
“g” Gram Weight/Mass
“sg” Slug Weight/Mass
“lbm” Pound Weight/Mass
“u” Atomic unit Weight/Mass
“ozm” Ounce Weight/Mass
“yr” Year Time
“day” Day Time
“hr” Hour Time
“mn” Minute Time
“sec” Second Time
“C” or “cel” Celsius Temperature
“F” or “fah” Fahrenheit Temperature
“K” or “kel” Kelvin Temperature
“tsp” Teaspoon Liquid Volume
“tbs” Tablespoon Liquid Volume
“oz” Fluid ounce Liquid Volume
“cup” Cup Liquid Volume
“pt” or “us_pt” US pint Liquid Volume
“uk_pt” UK pint Liquid Volume
“qt” Quart Liquid Volume
“gal” Gallon Liquid Volume
“l” or “lt” Liter Liquid Volume
“N” Newton Force
“dyn” or “dy” Dyne Force
“lbf” Pound Force Force
“Pa” or “p” Pascal Pressure
“atm” Atmosphere Pressure
“mmHg” mm of Mercury Pressure
“HP” or “h” Horsepower Power
“W” or “w” Watt Power
“J” Joule Energy
“e” Erg Energy
“c” Thermodynamic calorie Energy
“cal” IT calorie Energy
“eV” or “ev” Electron volt Energy
“HPh” or “hh” Horsepower-hour Energy
“Wh” or “wh” Watt-hour Energy
“flb” Foot-pound Energy
“BTU” or “btu” BTU Energy
“T” Tesla Magnetism
“ga” Gauss Magnetism

Let’s understand CONVERT Function with example.Consider this Spreadsheet,Where Distance is specified in meters.

Now, Let’s Write CONVERT Function for it, to Convert Distance unit meters into Kilometers,

  • number: Here, we can either specify number or cell name,

                                   =CONVERT(A2,

                                         OR

                                   =CONVERT(20,

  • from_unit: Now, we need to convert it from meters, therefore we would write CONVERT Function as,

                                  =CONVERT(A2,”m”,

  • to_unit: Here, we would define in which unit we want to convert our value from meters, therefore,

                                 =CONVERT(A2,”m”,”Km”)

And This is How we can use CONVERT Function in order to convert the value of one measurement unit into another unit.

We hope this article has helped you in understanding the concept of CONVERT Function.Share it if you find it helpful and help your friends and colleagues also who are new to Excel, Practice more to learn things in a better way.Write your queries to us anytime, we are always here to help you.

Add a Comment

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