CONVERT(x,from,to)
x: number
from: unit (string)
to: unit (string)
CONVERT returns a conversion from one measurement system to another. x is a value in from units that is to be converted into to units.
from and to can be any of the following:
Weight and mass:
'g' Gram
'sg' Slug
'lbm' Pound
'u' U (atomic mass)
'ozm' Ounce
Distance:
'm' Meter
'mi' Statute mile
'Nmi' Nautical mile
'in' Inch
'ft' Foot
'yd' Yard
'ang' Angstrom
'Pica' Pica Points
'picapt' Pica Points
'pica' Pica
Time:
'yr' Year
'day' Day
'hr' Hour
'mn' Minute
'sec' Second
Pressure:
'Pa' Pascal
'atm' Atmosphere
'mmHg' mm of Mercury
Force:
'N' Newton
'dyn' Dyne
'lbf' Pound force
Energy:
'J' Joule
'e' Erg
'c' Thermodynamic calorie
'cal' IT calorie
'eV' Electron volt
'HPh' Horsepower-hour
'Wh' Watt-hour
'flb' Foot-pound
'BTU' BTU
Power:
'HP' Horsepower
'W' Watt
Magnetism:
'T' Tesla
'ga' Gauss
Temperature:
'C' Degree Celsius
'F' Degree Fahrenheit
'K' Degree Kelvin
Liquid measure:
'tsp' Teaspoon
'tbs' Tablespoon
'oz' Fluid ounce
'cup' Cup
'pt' Pint
'qt' Quart
'gal' Gallon
'l' Liter
For metric units any of the following prefixes can be used:
'Y' yotta 1E+24
'Z' zetta 1E+21
'E' exa 1E+18
'P' peta 1E+15
'T' tera 1E+12
'G' giga 1E+09
'M' mega 1E+06
'k' kilo 1E+03
'h' hecto 1E+02
'e' deca (deka) 1E+01
'd' deci 1E-01
'c' centi 1E-02
'm' milli 1E-03
'u' micro 1E-06
'n' nano 1E-09
'p' pico 1E-12
'f' femto 1E-15
'a' atto 1E-18
'z' zepto 1E-21
'y' yocto 1E-24
If from and to are different types, CONVERT returns #N/A!
This function is Excel compatible (except "picapt").
This function is OpenFormula compatible.