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.


Syntax

CONVERT(Number; FromUnit; ToUnit)

Number is the number to be converted.

FromUnit is the unit from which conversion is taking place.

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).


Exemple

=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.


Arie

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

Descriere

Prefix

"ang2" ; "ang^2"

Square angstrom

Da

"ar"

Are

Da

"ft2" ; "ft^2"

Square foot

Nu

"ha"

Hectare

Nu

"in2" ; "in^2"

Square inch

Nu

"ly2" ; "ly^2"

Square light-year

Nu

"m2" ; "m^2"

Square meter

Da

"mi2" ; "mi^2"

Square international mile

Nu

"Morgen"

Morgen

Nu

"Nmi2" ; "Nmi^2"

Square nautical mile

Nu

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

Square pica point

Nu

"pica2" ; "pica^2"

Square pica

Nu

"uk_acre" ; "acre"

International acre

Nu

"us_acre"

US survey acre

Nu

"yd2" ; "yd^2"

Square yard

Nu


Energy

Unit symbol

Descriere

Prefix

"BTU" ; "btu"

British thermal unit

Nu

"c"

Thermochemical calorie

Da

"cal"

International Steam Table calorie

Da

"e"

erg

Da

"eV" ; "ev"

Electron volt

Da

"flb"

Foot-pound

Nu

"HPh" ; "hh"

Horsepower-hour

Nu

"J"

Joule

Da

"Wh" ; "wh"

Watt-hour

Da


Flux density

Unit symbol

Descriere

Prefix

"ga"

Gauss

Da

"T"

Tesla

Da


Force

Unit symbol

Descriere

Prefix

"dyn" ; "dy"

Dyne

Da

"N"

Newton

Da

"lbf"

Pound-force

Nu

"pond"

Pond

Da


Informații

Unit symbol

Descriere

Prefix

"bit"

Bit

Da

"byte"

Byte

Da


Length and distance

Unit symbol

Descriere

Prefix

"ang"

Angstrom

Da

"ell"

Ell

Nu

"ft"

Picior

Nu

"in"

Țol

Nu

"ly" ; "lightyear"

Light-year

Da

"m"

Metru

Da

"mi"

International mile

Nu

"Nmi"

Nautical mile

Nu

"parsec" ; "pc"

Parsec

Da

"Pica" ; "picapt"

Pica point

Nu

"pica"

Pica

Nu

"survey_mi"

US survey mile

Nu

"yd"

Yard

Nu


Mass and weight

Unit symbol

Descriere

Prefix

"cwt" ; "shweight"

Short hundredweight

Nu

"g"

Gram

Da

"grain"

Grain

Nu

"lbm"

Pound

Nu

"ozm"

Ounce

Nu

"pweight"

Pennyweight

Nu

"sg"

Slug

Nu

"stone"

Piatră

Nu

"ton"

Short ton

Nu

"u"

Unified atomic mass unit

Da

"uk_cwt" ; "lcwt" ; "hweight"

Long hundredweight

Nu

"uk_ton" ; "LTON" ; "brton"

Long ton

Nu


Putere

Unit symbol

Descriere

Prefix

"HP" ; "h"

Mechanical horsepower

Nu

"PS"

Pferdestärke or metric horsepower

Nu

"W" ; "w"

Watt

Da


Pressure

Unit symbol

Descriere

Prefix

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

Standard atmosphere

Da

"mmHg"

Millimeter of mercury

Da

"Pa"

Pascal

Da

"psi"

Pound per square inch

Nu

"Torr"

Torr

Nu


warning

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


Speed

Unit symbol

Descriere

Prefix

"admkn"

Admiralty knot

Nu

"kn"

International knot

Nu

"m/h" ; "m/hr"

Meters per hour

Da

"m/s" ; "m/sec"

Meters per second

Da

"mph"

Miles per hour

Nu


Temperature

Unit symbol

Descriere

Prefix

"C" ; "cel"

Degree Celsius

Nu

"F" ; "fah"

Degree Fahrenheit

Nu

"K" ; "kel"

Kelvin

Da

"Rank"

Degree Rankine

Nu

"Reau"

Degree Réaumur

Nu


Timp

Unit symbol

Descriere

Prefix

"day" ; "d"

Zi

Nu

"hr"

Ora

Nu

"mn" ; "min"

Minutul

Nu

"sec" ; "s"

a doua

Da

"yr"

An

Nu


Volum

Unit symbol

Descriere

Prefix

"ang3" ; "ang^3"

Cubic angstrom

Da

"barrel"

Oil barrel

Nu

"bushel"

US bushel

Nu

"cup"

US cup

Nu

"ft3" ; "ft^3"

Cubic foot

Nu

"gal"

US gallon

Nu

"Glass"(2)

Australian glass (200 milliliters)

Nu

"GRT" ; "regton"

Gross register tonnage

Nu

"Humpen"(2)

Humpen (500 milliliters)

Nu

"in3" ; "in^3"

Cubic inch

Nu

"l" ; "L" ; "lt"

Liter

Da

"ly3" ; "ly^3"

Cubic light-year

Nu

"m3" ; "m^3"

Cubic meter

Da

"mi3" ; "mi^3"

Cubic international mile

Nu

"Middy"(2)

Australian middy (285 milliliters)

Nu

"MTON"

Measurement ton

Nu

"Nmi3" ; "Nmi^3"

Cubic nautical mile

Nu

"oz"

US fluid ounce

Nu

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

Cubic pica point

Nu

"pica3" ; "pica^3"

Cubic pica

Nu

"pt" ; "us_pt"

US pint

Nu

"qt"

US quart

Nu

"Schooner"(2)

Australian schooner (425 milliliters)

Nu

"Sixpack"(2)

Six pack (2 liters)

Nu

"tbs"

US tablespoon

Nu

"tsp"

US teaspoon

Nu

"tspm"

Metric teaspoon

Nu

"uk_gal"

Imperial gallon

Nu

"uk_pt"

Imperial pint

Nu

"uk_qt"

Imperial quart

Nu

"yd3" ; "yd^3"

Cubic yard

Nu


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.


Prefixes

Decimal prefixes

Prefix

Multiplier

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

Prefix

Multiplier

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!