Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This post will inform you about what the CONVERT function is and how to use it. We will cover its formula syntax, applicable measurement systems for its usage, vital conditions to remember when applying it and also an example for you to play around with.
The CONVERT function is a mathematical function which transforms a number from one measurement system to another. For example, CONVERT can update a table of distances in miles to a table of distances in kilometres.
Image by Monsterkoi from Pixabay .
Syntax of the CONVERT Function
CONVERT (number ,from_unit ,to_unit )
Number refers to the value in from_units to convert.
From_unit is simply the units for number.
To_unit is the result units. The CONVERT function adopts these listed text values (enclosed in quotation marks) for from_unit and to_unit.
Image by 2331323 from Pixabay . Measurement systems to use the CONVERT Function with
Weight and Mass Weight and mass From_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 Distance From_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 Time From_unit or to_unit Year “yr” Day “day” or “d” Hour “hr” Minute “mn” or “min” Second “sec” or “s”
Pressure
Pressure From_unit or to_unit Pascal “Pa” (or “p”) Atmosphere “atm” (or “at”) mm of Mercury “mmHg” PSI “psi” Torr “Torr”
Force Force From_unit or to_unit Newton “N” Dyne “dyn” (or “dy”) Pound force “lbf” Pond “pond”
Energy
Energy From_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 Power From_unit or to_unit Horsepower “HP” (or “h”) Pferdestärke “PS” Watt “W” (or “w”)
Magnetism Magnetism From_unit or to_unit Tesla “T” Gauss “ga”
Temperature 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”
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 Area From_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 Information From_unit or to_unit Bit “bit” Byte “byte”
Speed 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”
The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.
Prefix Multiplier Abbreviation yotta 1E+24 “Y” zetta 1E+21 “Z” exa 1E+18 “E” peta 1E+15 “P” tera 1E+12 “T” giga 1E+09 “G” mega 1E+06 “M” kilo 1E+03 “k” hecto 1E+02 “h” dekao 1E+01 “da” or “e” deci 1E-01 “d” centi 1E-02 “c” milli 1E-03 “m” micro 1E-06 “u” nano 1E-09 “n” pico 1E-12 “p” femto 1E-15 “f” atto 1E-18 “a” zepto 1E-21 “z” yocto 1E-24 “y”
Binary Prefix Prefix Value Abbreviation Derived from yobi 2^80 = 1 208 925 819 614 629 174 706 176 “Yi” yotta zebi 2^70 = 1 180 591 620 717 411 303 424 “Zi” zetta exbi 2^60 = 1 152 921 504 606 846 976 “Ei” exa pebi 2^50 = 1 125 899 906 842 624 “Pi” peta tebi 2^40 = 1 099 511 627 776 “Ti” tera gibi 2^30 = 1 073 741 824 “Gi” giga mebi 2^20 = 1 048 576 “Mi” mega kibi 2^10 = 1024 “ki” kilo
Important Conditions of the CONVERT Function
If the input data types are incorrect, the CONVERT function yields the #VALUE! error value. When the unit is non-existent, CONVERT brings back the #N/A error value. Should the unit provide no support to a binary prefix, CONVERT captures the #N/A error value. If the units are in various groups, CONVERT obtains the #N/A error value. Unit names and prefixes are case-sensitive. Examples of the CONVERT Function
Formula Description Result =CONVERT(1, “lbm”, “kg”) Converts 1 pound mass to kilograms. 0.4535924 =CONVERT(68, “F”, “C”) Converts 68 degrees Fahrenheit to Celsius. 20 =CONVERT(2.5, “ft”, “sec”) Data types are different, thus an error is returned. #N/A =CONVERT(CONVERT(100,”ft”,”m”),”ft”,”m”) Converts 100 square feet into square metres. 9.290304
Copy the following to a blank worksheet
1 A 2 Data 6 Formula Description (Result) =CONVERT(A2,”C”,”F”) Convert 6 degrees Celsius to Fahrenheit (42.8). =CONVERT(A2,”tsp”,”tbs”) Convert 6 teaspoons to tablespoons (2). Convert 6 gallons to liters (22.71741274). =CONVERT(A2,”mi”,”km”) Convert 6 miles to kilometres (9.656064). =CONVERT(A2,”km”,”mi”) Convert 6 kilometres to miles (3.728227153). =CONVERT(A2,”in”,”ft”) Convert 6 inches to feet (0.5). =CONVERT(A2,”cm”,”in”) Convert 6 centimetres to inches (2.362204724).
Other Maths Functions Topics
Round a number to the decimal places I want
Find the remainder with MOD
Build random number generators with RAND
Generate random number between numbers you specify with RANDBETWEEN
SUBTOTAL function
ROUND function
Round a number
Like this: Like Loading...
