CONVERT function

Converts a value from one unit of measurement to the corresponding value in another unit of measurement. Enter the units of measurement directly as text in quotation marks or as a reference. The units of measurement specified through the arguments must match the supported unit symbols, which are case-sensitive. For example, the symbol for the unit "newton" is the uppercase "N".

The measurement units recognized by CONVERT fall into 13 groups, which are listed below. CONVERT will perform conversions between any two units within one group but reject any request to convert between units in different groups.

You can also add binary and decimal prefixes to units of measurement that support them. The list of all prefixes and their corresponding multipliers are shown below.

warning

This function may not be compatible with other spreadsheet software.


แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

CONVERT(Number; FromUnit; ToUnit)

แƒ แƒ˜แƒชแƒฎแƒ•แƒ˜ แƒแƒ แƒ˜แƒก แƒ’แƒแƒ แƒ“แƒแƒกแƒแƒฅแƒ›แƒœแƒ”แƒšแƒ˜ แƒชแƒ˜แƒคแƒ แƒฃแƒšแƒ˜ แƒ›แƒœแƒ˜แƒจแƒ•แƒœแƒ”แƒšแƒแƒ‘แƒ.

แƒ”แƒ แƒ—แƒ”แƒฃแƒšแƒ˜แƒ“แƒแƒœ: แƒ”แƒ แƒ—แƒ”แƒฃแƒšแƒ˜ แƒ แƒแƒ›แƒšแƒ˜แƒ“แƒแƒœแƒแƒช แƒฎแƒ“แƒ”แƒ‘แƒ แƒ’แƒแƒ“แƒแƒงแƒ•แƒแƒœแƒ.

ToUnit is the unit to which conversion is taking place. Both units must be of the same type.

warning

If FromUnit and ToUnit are not valid units from the same group, then CONVERT reports an invalid argument error (Err:502).


แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ”แƒ‘แƒ˜

=CONVERT(-10; "C"; "F")

Here the function converts -10 degrees Celsius to degrees Fahrenheit, returning the value 14. There is not a simple multiplicative relationship between temperature units, as different reference points are used. Hence, as in this case, an input negative number may be converted to a positive value.

=CONVERT(3.5; "mi"; "yd")

Here the function converts 3.5 international miles to yards, returning the value 6160. Both units are in the Length and distance group.

=CONVERT(256; "Gibit"; "Mibyte")

Here the function converts 256 gigibits to mebibytes, returning the value 32768. Both units (bit and byte) are in the Information group and support binary prefixes.

=CONVERT(1; "dyn"; "e")

Here the function returns an invalid argument error (Err:502) because the two units (dyne and erg) are in different groups (Force and Energy respectively).

Units of measurement

Below are the unit measurement groups supported by the CONVERT function. Be aware that conversions can only happen between units that belong to the same group.

note

The column Prefix indicates whether or not a given unit of measurement supports prefixes.


แƒแƒšแƒแƒ’แƒ˜

note

Some measurement units have more than one accepted symbol. The accepted unit symbols are separated by semicolons in the Unit symbol column.


Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"ang2" ; "ang^2"

Square angstrom

แƒ“แƒ˜แƒแƒฎ

"ar"

แƒแƒ แƒ˜

แƒ“แƒ˜แƒแƒฎ

"ft2" ; "ft^2"

Square foot

แƒแƒ แƒ

"ha"

แƒฐแƒ”แƒฅแƒขแƒแƒ แƒ˜

แƒแƒ แƒ

"in2" ; "in^2"

Square inch

แƒแƒ แƒ

"ly2" ; "ly^2"

Square light-year

แƒแƒ แƒ

"m2" ; "m^2"

Square meter

แƒ“แƒ˜แƒแƒฎ

"mi2" ; "mi^2"

Square international mile

แƒแƒ แƒ

"Morgen"

แƒ›แƒแƒ แƒ’แƒ”แƒœแƒ˜

แƒแƒ แƒ

"Nmi2" ; "Nmi^2"

Square nautical mile

แƒแƒ แƒ

"Pica2" ; "Pica^2" ; "picapt2" ; "picapt^2"

Square pica point

แƒแƒ แƒ

"pica2" ; "pica^2"

Square pica

แƒแƒ แƒ

"uk_acre" ; "acre"

International acre

แƒแƒ แƒ

"us_acre"

US survey acre

แƒแƒ แƒ

"yd2" ; "yd^2"

Square yard

แƒแƒ แƒ


แƒ”แƒœแƒ”แƒ แƒ’แƒ˜แƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"BTU" ; "btu"

British thermal unit

แƒแƒ แƒ

"c"

Thermochemical calorie

แƒ“แƒ˜แƒแƒฎ

"cal"

International Steam Table calorie

แƒ“แƒ˜แƒแƒฎ

"e"

แƒ”แƒ แƒ’แƒ˜

แƒ“แƒ˜แƒแƒฎ

"eV" ; "ev"

Electron volt

แƒ“แƒ˜แƒแƒฎ

"flb"

แƒคแƒฃแƒขแƒ˜-แƒ’แƒ˜แƒ แƒ•แƒแƒœแƒฅแƒ

แƒแƒ แƒ

"HPh" ; "hh"

แƒชแƒฎแƒซ-แƒกแƒ—

แƒแƒ แƒ

"J"

แƒฏแƒแƒฃแƒšแƒ˜

แƒ“แƒ˜แƒแƒฎ

"Wh" ; "wh"

แƒ•แƒแƒข-แƒกแƒแƒแƒ—แƒ˜

แƒ“แƒ˜แƒแƒฎ


Flux density

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"ga"

แƒ’แƒแƒฃแƒกแƒ˜

แƒ“แƒ˜แƒแƒฎ

"T"

แƒขแƒ”แƒกแƒšแƒ

แƒ“แƒ˜แƒแƒฎ


แƒซแƒแƒšแƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"dyn" ; "dy"

แƒ“แƒ˜แƒœแƒ˜

แƒ“แƒ˜แƒแƒฎ

"N"

แƒœแƒ˜แƒฃแƒขแƒแƒœแƒ˜

แƒ“แƒ˜แƒแƒฎ

"lbf"

แƒ’แƒ˜แƒ แƒ•แƒแƒœแƒฅแƒ-แƒซแƒแƒšแƒ

แƒแƒ แƒ

"pond"

แƒ’แƒ˜แƒ แƒ•แƒแƒœแƒฅแƒ

แƒ“แƒ˜แƒแƒฎ


แƒ˜แƒœแƒคแƒแƒ แƒ›แƒแƒชแƒ˜แƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"bit"

แƒ‘แƒ˜แƒขแƒ˜

แƒ“แƒ˜แƒแƒฎ

"byte"

แƒ‘แƒแƒ˜แƒขแƒ˜

แƒ“แƒ˜แƒแƒฎ


Length and distance

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"ang"

แƒแƒœแƒกแƒ’แƒขแƒ แƒ”แƒ›แƒ˜

แƒ“แƒ˜แƒแƒฎ

"ell"

แƒ”แƒšแƒ˜

แƒแƒ แƒ

"ft"

แƒคแƒฃแƒขแƒ˜

แƒแƒ แƒ

"in"

แƒ“แƒฃแƒ˜แƒ›แƒ˜

แƒแƒ แƒ

"ly" ; "lightyear"

แƒกแƒ˜แƒœแƒแƒ—แƒšแƒ˜แƒก แƒฌแƒ”แƒšแƒ˜แƒฌแƒแƒ“แƒ˜

แƒ“แƒ˜แƒแƒฎ

"m"

แƒ›แƒ”แƒขแƒ แƒ˜

แƒ“แƒ˜แƒแƒฎ

"mi"

International mile

แƒแƒ แƒ

"Nmi"

Nautical mile

แƒแƒ แƒ

"parsec" ; "pc"

แƒžแƒแƒ แƒกแƒ”แƒ™แƒ˜

แƒ“แƒ˜แƒแƒฎ

"Pica" ; "picapt"

Pica point

แƒแƒ แƒ

"pica"

แƒžแƒ˜แƒ™แƒ

แƒแƒ แƒ

"survey_mi"

US survey mile

แƒแƒ แƒ

"yd"

แƒ˜แƒแƒ แƒ“แƒ˜

แƒแƒ แƒ


Mass and weight

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"cwt" ; "shweight"

Short hundredweight

แƒแƒ แƒ

"g"

แƒ’แƒ แƒแƒ›แƒ˜

แƒ“แƒ˜แƒแƒฎ

"grain"

แƒ’แƒ แƒแƒœแƒ˜

แƒแƒ แƒ

"lbm"

แƒ’แƒ˜แƒ แƒ•แƒแƒœแƒฅแƒ

แƒแƒ แƒ

"ozm"

แƒฃแƒœแƒชแƒ˜แƒ

แƒแƒ แƒ

"pweight"

แƒžแƒ”แƒœแƒ˜แƒ•แƒ”แƒ˜แƒ—แƒ˜

แƒแƒ แƒ

"sg"

แƒกแƒšแƒแƒ’แƒ˜

แƒแƒ แƒ

"stone"

stone

แƒแƒ แƒ

"ton"

Short ton

แƒแƒ แƒ

"u"

Unified atomic mass unit

แƒ“แƒ˜แƒแƒฎ

"uk_cwt" ; "lcwt" ; "hweight"

Long hundredweight

แƒแƒ แƒ

"uk_ton" ; "LTON" ; "brton"

Long ton

แƒแƒ แƒ


แƒกแƒ˜แƒ›แƒซแƒšแƒแƒ•แƒ แƒ”

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"HP" ; "h"

Mechanical horsepower

แƒแƒ แƒ

"PS"

Pferdestรคrke or metric horsepower

แƒแƒ แƒ

"W" ; "w"

แƒ•แƒแƒขแƒ˜

แƒ“แƒ˜แƒแƒฎ


แƒฌแƒœแƒ”แƒ•แƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"atm" ; ("at")(1)

Standard atmosphere

แƒ“แƒ˜แƒแƒฎ

"mmHg"

Millimeter of mercury

แƒ“แƒ˜แƒแƒฎ

"Pa"

แƒžแƒแƒกแƒ™แƒแƒšแƒ˜

แƒ“แƒ˜แƒแƒฎ

"psi"

Pound per square inch

แƒแƒ แƒ

"Torr"

แƒขแƒแƒ แƒ˜

แƒแƒ แƒ


warning

1 - The "at" unit is deprecated. Use "atm" instead.


แƒกแƒ˜แƒฉแƒฅแƒแƒ แƒ”

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"admkn"

Admiralty knot

แƒแƒ แƒ

"kn"

International knot

แƒแƒ แƒ

"m/h" ; "m/hr"

Meters per hour

แƒ“แƒ˜แƒแƒฎ

"m/s" ; "m/sec"

Meters per second

แƒ“แƒ˜แƒแƒฎ

"mph"

Miles per hour

แƒแƒ แƒ


แƒขแƒ”แƒ›แƒžแƒ”แƒ แƒแƒขแƒฃแƒ แƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"C" ; "cel"

Degree Celsius

แƒแƒ แƒ

"F" ; "fah"

Degree Fahrenheit

แƒแƒ แƒ

"K" ; "kel"

แƒ™แƒ”แƒšแƒ•แƒ˜แƒœแƒ˜

แƒ“แƒ˜แƒแƒฎ

"Rank"

Degree Rankine

แƒแƒ แƒ

"Reau"

Degree Rรฉaumur

แƒแƒ แƒ


แƒ“แƒ แƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"day" ; "d"

แƒ“แƒฆแƒ”

แƒแƒ แƒ

"hr"

แƒกแƒแƒแƒ—แƒ˜

แƒแƒ แƒ

"mn" ; "min"

แƒฌแƒฃแƒ—แƒ˜

แƒแƒ แƒ

"sec" ; "s"

แƒฌแƒแƒ›แƒ˜

แƒ“แƒ˜แƒแƒฎ

"yr"

แƒฌแƒ”แƒšแƒ˜

แƒแƒ แƒ


แƒ›แƒแƒชแƒฃแƒšแƒแƒ‘แƒ

Unit symbol

แƒแƒฆแƒฌแƒ”แƒ แƒ

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

"ang3" ; "ang^3"

Cubic angstrom

แƒ“แƒ˜แƒแƒฎ

"barrel"

Oil barrel

แƒแƒ แƒ

"bushel"

US bushel

แƒแƒ แƒ

"cup"

US cup

แƒแƒ แƒ

"ft3" ; "ft^3"

Cubic foot

แƒแƒ แƒ

"gal"

US gallon

แƒแƒ แƒ

"Glass"(2)

Australian glass (200 milliliters)

แƒแƒ แƒ

"GRT" ; "regton"

Gross register tonnage

แƒแƒ แƒ

"Humpen"(2)

Humpen (500 milliliters)

แƒแƒ แƒ

"in3" ; "in^3"

Cubic inch

แƒแƒ แƒ

"l" ; "L" ; "lt"

แƒšแƒ˜แƒขแƒ แƒ˜

แƒ“แƒ˜แƒแƒฎ

"ly3" ; "ly^3"

Cubic light-year

แƒแƒ แƒ

"m3" ; "m^3"

Cubic meter

แƒ“แƒ˜แƒแƒฎ

"mi3" ; "mi^3"

Cubic international mile

แƒแƒ แƒ

"Middy"(2)

Australian middy (285 milliliters)

แƒแƒ แƒ

"MTON"

Measurement ton

แƒแƒ แƒ

"Nmi3" ; "Nmi^3"

Cubic nautical mile

แƒแƒ แƒ

"oz"

US fluid ounce

แƒแƒ แƒ

"Pica3" ; "Pica^3" ; "picapt3" ; "picapt^3"

Cubic pica point

แƒแƒ แƒ

"pica3" ; "pica^3"

Cubic pica

แƒแƒ แƒ

"pt" ; "us_pt"

US pint

แƒแƒ แƒ

"qt"

US quart

แƒแƒ แƒ

"Schooner"(2)

Australian schooner (425 milliliters)

แƒแƒ แƒ

"Sixpack"(2)

Six pack (2 liters)

แƒแƒ แƒ

"tbs"

US tablespoon

แƒแƒ แƒ

"tsp"

US teaspoon

แƒแƒ แƒ

"tspm"

Metric teaspoon

แƒแƒ แƒ

"uk_gal"

Imperial gallon

แƒแƒ แƒ

"uk_pt"

Imperial pint

แƒแƒ แƒ

"uk_qt"

Imperial quart

แƒแƒ แƒ

"yd3" ; "yd^3"

Cubic yard

แƒแƒ แƒ


note

2 - These units are not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard for the CONVERT function. They are preserved for backward compatibility.


แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ”แƒ‘แƒ˜

Decimal prefixes

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

แƒ›แƒแƒ›แƒ แƒแƒ•แƒšแƒ˜

Y (yotta)

1024

Z (zetta)

1021

E (exa)

1018

P (peta)

1015

T (tera)

1012

G (giga)

109

M (mega)

106

k (kilo)

103

h (hecto)

102

e (deca)

101

d (deci)

10-1

c (centi)

10-2

m (milli)

10-3

u (micro)

10-6

n (nano)

10-9

p (pico)

10-12

f (femto)

10-15

a (atto)

10-18

z (zepto)

10-21

y (yocto)

10-24


Binary prefixes

แƒžแƒ แƒ”แƒคแƒ˜แƒฅแƒกแƒ˜

แƒ›แƒแƒ›แƒ แƒแƒ•แƒšแƒ˜

Yi (yobi)

280

Zi (zebi)

270

Ei (exbi)

260

Pi (pebi)

250

Ti (tebi)

240

Gi (gibi)

230

Mi (mebi)

220

ki (kibi)

210


Technical information

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

ORG.OPENOFFICE.CONVERT

Please support us!