Engineering - CONVERT Function
Description
The CONVERT function converts a number from one measurement system to another.
For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.
Syntax
CONVERT (number,from_unit,to_unit)
Arguments
Argument |
Description |
Required/ Optional |
Number |
The value in from_units to convert. |
Required |
From_unit |
The units for number. |
Required |
To_unit |
The units for the result. |
Required |
Notes
The from_unit and to_unit arguments should be Compatible i.e. they may not be from different measurement types (e.g. temperature and distance). If you attempt to convert between two incompatible measurement types, Excel will return the #N/A error.
CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit −
Weight & Mass Units |
Weight and mass |
From_unit or to_unit |
Gram |
"g" |
Slug |
"sg" |
Pound Mass |
"lbm" |
U (Atomic Mass Unit) |
"u" |
Ounce Mass |
"ozm" |
Grain |
"grain" |
U.S. hundredweight |
"cwt" (or "shweight") |
Imperial hundredweight |
"uk_cwt" (or "lcwt" or "hweight") |
Stone |
"stone" |
Weight & Mass Units |
Weight and mass |
From_unit or to_unit |
Ton |
"ton" |
Imperial ton |
"uk_ton" (or "LTON" or "brton") |
Distance Units |
Distance |
From_unit or to_unit |
Meter |
"m" |
Statute Mile |
"mi" |
Nautical Mile |
"Nmi" |
Inch |
"in" |
Foot |
"ft" |
Yard |
"yd" |
Angstrom |
"ang" |
Pica (1/6 inch) |
"pica" |
Pica (1/72 inch) |
"Pica" (or "Picapt") |
Ell |
"ell" |
Light-year |
"ly" |
Parsec |
"parsec" (or "pc") |
U.S. survey mile |
"survey_mi" |
Time Units |
Time |
From_unit or to_unit |
Year |
"yr" |
Day |
"day" |
Hour |
"hr" |
Minute |
"mn" |
Second |
"sec" |
Pressure Units |
Pressure |
From_unit or to_unit |
Pascal |
"Pa" (or "p") |
Atmosphere |
"atm" (or "at") |
mm of Mercury |
"mmHg" |
PSI |
"psi" |
Torr |
"Torr" |
Force Units |
Force |
From_unit or to_unit |
Newton |
"N" |
Dyne |
"dyn" (or "dy") |
Pound Force |
"lbf" |
Pond |
"pond" |
Energy Units |
Energy |
From_unit or to_unit |
Joule |
"J" |
Erg |
"e" |
Thermodynamic |
Calorie "c" |
IT Calorie |
"cal" |
Electron Volt |
"eV" (or "ev") |
Horsepower-Hour |
"HPh" |
Watt-Hour |
"Wh" |
Foot-Pound |
"flb" |
BTU |
"BTU" (or "btu") |
Power Units |
Power |
From_unit or to_unit |
Horsepower |
"HP" (or "h") |
Watt |
"W" (or "w") |
Pferdestärke |
"PS" |
Magnetism Units |
Magnetism |
From_unit or to_unit |
Tesla |
"T" |
Gauss |
"ga" |
Temperature Units |
Temperature |
From_unit or to_unit |
Degree Celsius |
"C" (or "cel") |
Degree Fahrenheit |
"F" (or "fah") |
Kelvin |
"K" (or "kel") |
Degrees Rankine |
"Rank" |
Degrees Réaumur |
"Reau" |
Liquid (Volume) Units |
Liquid (Volume) |
From_unit or to_unit |
Teaspoon |
"tsp" |
Tablespoon |
"tbs" |
Fluid Ounce |
"oz" |
Cup |
"cup" |
U.S. Pint |
"pt" (or "us_pt") |
U.K. Pint |
"uk_pt" |
Quart |
"qt" |
Imperial quart |
"uk_qt" |
Gallon |
"gal" |
Imperial gallon |
"uk_gal" |
Liter |
"l" (or "lt") |
Cubic angstrom |
"ang3" (or "ang^3") |
U.S. oil barrel |
"barrel" |
U.S. bushel |
"bushel" |
Cubic feet |
"ft3" (or "ft^3") |
Cubic inch |
"in3" (or "in^3") |
Cubic light-year |
"ly3" (or "ly^3") |
Cubic meter |
"m3" (or "m^3") |
Cubic mile |
"mi3" (or "mi^3") |
Cubic yard |
"yd3" (or "yd^3") |
Cubic nautical mile |
"Nmi3" (or "Nmi^3") |
Cubic Pica |
"Picapt3" (or "Picapt^3" or "Pica3" or "Pica^3") |
Gross Registered Ton |
"GRT" (or "regton") |
Measurement ton |
"MTON" |
Area Units |
Area |
From_unit or to_unit |
International acre |
"uk_acre" |
U.S. survey acre |
"us_acre" |
Square angstrom |
"ang2" (or "ang^2") |
Are |
"ar" |
Square feet |
"ft2" (or "ft^2") |
Hectare |
"ha" |
Square inches |
"in2" (or "in^2") |
Square light-year |
"ly2" (or "ly^2") |
Square meters |
"m2" (or "m^2") |
Morgen |
"Morgen" |
Square miles |
"mi2" (or "mi^2") |
Square nautical miles |
"Nmi2" (or "Nmi^2") |
Area Units |
Area |
From_unit or to_unit |
Square Pica |
"Picapt2" (or "Pica2" or "Pica^2" or "Picapt^2") |
Square yards |
"yd2" (or "yd^2") |
Information Units |
Information |
From_unit or to_unit |
Bit |
"bit" |
Byte |
"byte" |
Speed Units |
Speed |
From_unit or to_unit |
Admiralty knot |
"admkn" |
Knot |
"kn" |
Meters per hour |
"m/h" (or "m/hr") |
Meters per second |
"m/s" (or "m/sec") |
Miles per hour |
"mph" |
In addition, the following text can be prepended any metric to_unit or from_unit. For example, the "c" prepended to the meter unit, "m" becomes "cm" to denote centimeters.
Prefix |
Prefix Value |
Abbrevation |
yotta |
1.00E+24 |
"Y" |
zetta |
1.00E+21 |
"Z" |
exa |
1.00E+18 |
"E" |
peta |
1.00E+15 |
"P" |
tera |
1.00E+12 |
"T" |
giga |
1.00E+09 |
"G" |
mega |
1.00E+06 |
"M" |
kilo |
1.00E+03 |
"k" |
hecto |
1.00E+02 |
"h" |
dekao |
1.00E+01 |
"e" (or "da") |
deci |
1.00E-01 |
"d" |
centi |
1.00E-02 |
"c" |
milli |
1.00E-03 |
"m" |
micro |
1.00E-06 |
"u" |
nano |
1.00E-09 |
"n" |
pico |
1.00E-12 |
"p" |
femto |
1.00E-15 |
"f" |
atto |
1.00E-18 |
"a" |
zepto |
1.00E-21 |
"z" |
yocto |
1.00E-24 |
"y" |
Binary Prefix |
Prefix Value |
Abbrevation |
Derived from |
yobi |
2^80 |
"Yi" |
yotta |
zebi |
2^70 |
"Zi" |
zetta |
exbi |
2^60 |
"Ei" |
exa |
pebi |
2^50 |
"Pi" |
|
tebi |
2^40 |
"Ti" |
tera |
gibi |
2^30 |
"Gi" |
giga |
mebi |
2^20 |
"Mi" |
mega |
kibi |
2^10 |
"ki" |
kilo |
Notes
If the input data types are incorrect, CONVERT returns the #VALUE! error value.
If the unit does not exist, CONVERT returns the #N/A error value.
If the unit does not support a binary prefix, CONVERT returns the #N/A error value.
If the units are in different groups, CONVERT returns the #N/A error value.
Unit names and prefixes are case-sensitive.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_engineering_functions.htm