Excel CONVERT function arguments

This function is really straightforward: it simply converts amounts from one unit to another. In the example below the amount of ice-cream consumed annually is expressed in the gallons in column B is being converted to litres in column C.

This is a handy function not in the CAT curriculum that can be used in the PAT to meet the Level 4 requirement in the Phase 2 Excel analysis!

As always, when using Excel’s functions, it is best to use the Insert Function button to access the Function Arguments dialog which contains the help you need.

The full set of units is listed in the Help function in the following categories:

  • Weight and Mass
  • Distance
  • Time
  • Pressure
  • Force
  • Energy
  • Power
  • Magnetism
  • Temperature
  • Volume
  • Area
  • Information
  • Speed
Weight and massFrom_unit or to_unit
Gram“g”
Slug“sg”
Pound mass (avoirdupois)“lbm”
U (atomic mass unit)“u”
Ounce mass (avoirdupois)“ozm”
Grain“grain”
U.S. (short) hundredweight“cwt” or “shweight”
Imperial hundredweight“uk_cwt” or “lcwt” (“hweight”)
Stone“stone”
Ton“ton”
Imperial ton“uk_ton” or “LTON” (“brton”)

Distance

DistanceFrom_unit or to_unit
Meter“m”
Statute mile“mi”
Nautical mile“Nmi”
Inch“in”
Foot“ft”
Yard“yd”
Angstrom“ang”
Ell“ell”
Light-year“ly”
Parsec“parsec” or “pc”
Pica (1/72 inch)“Picapt” or “Pica”
Pica (1/6 inch)“pica”
U.S survey mile (statute mile)“survey_mi”

Time

TimeFrom_unit or to_unit
Year“yr”
Day“day” or “d”
Hour“hr”
Minute“mn” or “min”
Second“sec” or “s”

Pressure

PressureFrom_unit or to_unit
Pascal“Pa” (or “p”)
Atmosphere“atm” (or “at”)
mm of Mercury“mmHg”
PSI“psi”
Torr“Torr”

Force

ForceFrom_unit or to_unit
Newton“N”
Dyne“dyn” (or “dy”)
Pound force“lbf”
Pond“pond”

Energy

EnergyFrom_unit or to_unit
Joule“J”
Erg“e”
Thermodynamic calorie“c”
IT calorie“cal”
Electron volt“eV” (or “ev”)
Horsepower-hour“HPh” (or “hh”)
Watt-hour“Wh” (or “wh”)
Foot-pound“flb”
BTU“BTU” (or “btu”)

Power

PowerFrom_unit or to_unit
Horsepower“HP” (or “h”)
Pferdestärke“PS”
Watt“W” (or “w”)

Magnetism

MagnetismFrom_unit or to_unit
Tesla“T”
Gauss“ga”

Temperature

TemperatureFrom_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”

Volume

Volume (or liquid measure)From_unit or to_unit
Teaspoon“tsp”
Modern teaspoon“tspm”
Tablespoon“tbs”
Fluid ounce“oz”
Cup“cup”
U.S. pint“pt” (or “us_pt”)
U.K. pint“uk_pt”
Quart“qt”
Imperial quart (U.K.)“uk_qt”
Gallon“gal”
Imperial gallon (U.K.)“uk_gal”
Liter“l” or “L” (“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”, “Picapt^3”, “Pica3” or “Pica^3”
Gross Registered Ton“GRT” (“regton”)
Measurement ton (freight ton)“MTON”

Area

AreaFrom_unit or to_unit
International acre“uk_acre”
U.S. survey/statute 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”
Square Pica“Picapt2”, “Pica2”, “Pica^2” or “Picapt^2”
Square yards“yd2” or “yd^2”

Information

InformationFrom_unit or to_unit
Bit“bit”
Byte“byte”

Speed

SpeedFrom_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”

The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.

PrefixMultiplierAbbreviation
yotta1E+24“Y”
zetta1E+21“Z”
exa1E+18“E”
peta1E+15“P”
tera1E+12“T”
giga1E+09“G”
mega1E+06“M”
kilo1E+03“k”
hecto1E+02“h”
dekao1E+01“da” or “e”
deci1E-01“d”
centi1E-02“c”
milli1E-03“m”
micro1E-06“u”
nano1E-09“n”
pico1E-12“p”
femto1E-15“f”
atto1E-18“a”
zepto1E-21“z”
yocto1E-24“y”
Binary PrefixPrefix ValueAbbreviationDerived from
yobi2^80 = 1 208 925 819 614 629 174 706 176“Yi”yotta
zebi2^70 = 1 180 591 620 717 411 303 424“Zi”zetta
exbi2^60 = 1 152 921 504 606 846 976“Ei”exa
pebi2^50 = 1 125 899 906 842 624“Pi”peta
tebi2^40 = 1 099 511 627 776“Ti”tera
gibi2^30 = 1 073 741 824“Gi”giga
mebi2^20 = 1 048 576“Mi”mega
kibi2^10 = 1024“ki”kilo

By MisterFoxOnline

CAT Educator

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.