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.


Składnia

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


Przykłady

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


Area

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

Description

Prefix

"ang2" ; "ang^2"

Square angstrom

Tak

"ar"

Are

Tak

"ft2" ; "ft^2"

Square foot

Nie

"ha"

Hectare

Nie

"in2" ; "in^2"

Square inch

Nie

"ly2" ; "ly^2"

Square light-year

Nie

"m2" ; "m^2"

Square meter

Tak

"mi2" ; "mi^2"

Square international mile

Nie

"Morgen"

Morgen

Nie

"Nmi2" ; "Nmi^2"

Square nautical mile

Nie

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

Square pica point

Nie

"pica2" ; "pica^2"

Square pica

Nie

"uk_acre" ; "acre"

International acre

Nie

"us_acre"

US survey acre

Nie

"yd2" ; "yd^2"

Square yard

Nie


Energy

Unit symbol

Description

Prefix

"BTU" ; "btu"

British thermal unit

Nie

"c"

Thermochemical calorie

Tak

"cal"

International Steam Table calorie

Tak

"e"

erg

Tak

"eV" ; "ev"

Electron volt

Tak

"flb"

Foot-pound

Nie

"HPh" ; "hh"

Horsepower-hour

Nie

"J"

Joule

Tak

"Wh" ; "wh"

Watt-hour

Tak


Flux density

Unit symbol

Description

Prefix

"ga"

Gauss

Tak

"T"

Tesla

Tak


Force

Unit symbol

Description

Prefix

"dyn" ; "dy"

Dyne

Tak

"N"

Newton

Tak

"lbf"

Pound-force

Nie

"pond"

Pond

Tak


Information

Unit symbol

Description

Prefix

"bit"

Bit

Tak

"byte"

Byte

Tak


Length and distance

Unit symbol

Description

Prefix

"ang"

Angstrom

Tak

"ell"

Ell

Nie

"ft"

Foot

Nie

"in"

Inch

Nie

"ly" ; "lightyear"

Light-year

Tak

"m"

Meter

Tak

"mi"

International mile

Nie

"Nmi"

Nautical mile

Nie

"parsec" ; "pc"

Parsec

Tak

"Pica" ; "picapt"

Pica point

Nie

"pica"

Pica

Nie

"survey_mi"

US survey mile

Nie

"yd"

Yard

Nie


Mass and weight

Unit symbol

Description

Prefix

"cwt" ; "shweight"

Short hundredweight

Nie

"g"

Gram

Tak

"grain"

Grain

Nie

"lbm"

Pound

Nie

"ozm"

Ounce

Nie

"pweight"

Pennyweight

Nie

"sg"

Slug

Nie

"stone"

Stone

Nie

"ton"

Short ton

Nie

"u"

Unified atomic mass unit

Tak

"uk_cwt" ; "lcwt" ; "hweight"

Long hundredweight

Nie

"uk_ton" ; "LTON" ; "brton"

Long ton

Nie


Power

Unit symbol

Description

Prefix

"HP" ; "h"

Mechanical horsepower

Nie

"PS"

Pferdestärke or metric horsepower

Nie

"W" ; "w"

Watt

Tak


Pressure

Unit symbol

Description

Prefix

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

Standard atmosphere

Tak

"mmHg"

Millimeter of mercury

Tak

"Pa"

Pascal

Tak

"psi"

Pound per square inch

Nie

"Torr"

Torr

Nie


warning

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


Speed

Unit symbol

Description

Prefix

"admkn"

Admiralty knot

Nie

"kn"

International knot

Nie

"m/h" ; "m/hr"

Meters per hour

Tak

"m/s" ; "m/sec"

Meters per second

Tak

"mph"

Miles per hour

Nie


Temperature

Unit symbol

Description

Prefix

"C" ; "cel"

Degree Celsius

Nie

"F" ; "fah"

Degree Fahrenheit

Nie

"K" ; "kel"

Kelvin

Tak

"Rank"

Degree Rankine

Nie

"Reau"

Degree Réaumur

Nie


Time

Unit symbol

Description

Prefix

"day" ; "d"

Day

Nie

"hr"

Hour

Nie

"mn" ; "min"

Minute

Nie

"sec" ; "s"

Second

Tak

"yr"

Year

Nie


Volume

Unit symbol

Description

Prefix

"ang3" ; "ang^3"

Cubic angstrom

Tak

"barrel"

Oil barrel

Nie

"bushel"

US bushel

Nie

"cup"

US cup

Nie

"ft3" ; "ft^3"

Cubic foot

Nie

"gal"

US gallon

Nie

"Glass"(2)

Australian glass (200 milliliters)

Nie

"GRT" ; "regton"

Gross register tonnage

Nie

"Humpen"(2)

Humpen (500 milliliters)

Nie

"in3" ; "in^3"

Cubic inch

Nie

"l" ; "L" ; "lt"

Liter

Tak

"ly3" ; "ly^3"

Cubic light-year

Nie

"m3" ; "m^3"

Cubic meter

Tak

"mi3" ; "mi^3"

Cubic international mile

Nie

"Middy"(2)

Australian middy (285 milliliters)

Nie

"MTON"

Measurement ton

Nie

"Nmi3" ; "Nmi^3"

Cubic nautical mile

Nie

"oz"

US fluid ounce

Nie

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

Cubic pica point

Nie

"pica3" ; "pica^3"

Cubic pica

Nie

"pt" ; "us_pt"

US pint

Nie

"qt"

US quart

Nie

"Schooner"(2)

Australian schooner (425 milliliters)

Nie

"Sixpack"(2)

Six pack (2 liters)

Nie

"tbs"

US tablespoon

Nie

"tsp"

US teaspoon

Nie

"tspm"

Metric teaspoon

Nie

"uk_gal"

Imperial gallon

Nie

"uk_pt"

Imperial pint

Nie

"uk_qt"

Imperial quart

Nie

"yd3" ; "yd^3"

Cubic yard

Nie


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