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.

This function may not be compatible with other spreadsheet software.

Sözdizimi

CONVERT(Number; FromUnit; ToUnit)

Sayı birimden birime dönüştürülecek değerdir.

Birimden çevrilecek sayının birimidir.

Birime çevrilmiş sayının birimidir. Her iki birimde aynı olmak zorundadır.

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

Örnekler

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

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

Alan

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

Unit symbol	Açıklama	OnEk
"ang2" ; "ang^2"	Square angstrom	Evet
"ar"	Are	Evet
"ft2" ; "ft^2"	Square foot	No
"ha"	Hectare	No
"in2" ; "in^2"	Square inch	No
"ly2" ; "ly^2"	Square light-year	No
"m2" ; "m^2"	Square meter	Evet
"mi2" ; "mi^2"	Square international mile	No
"Morgen"	Morgen	No
"Nmi2" ; "Nmi^2"	Square nautical mile	No
"Pica2" ; "Pica^2" ; "picapt2" ; "picapt^2"	Square pica point	No
"pica2" ; "pica^2"	Square pica	No
"uk_acre" ; "acre"	International acre	No
"us_acre"	US survey acre	No
"yd2" ; "yd^2"	Square yard	No

Enerji

Unit symbol	Açıklama	OnEk
"BTU" ; "btu"	British thermal unit	No
"c"	Thermochemical calorie	Evet
"cal"	International Steam Table calorie	Evet
"e"	erg	Evet
"eV" ; "ev"	Electron volt	Evet
"flb"	Foot-pound	No
"HPh" ; "hh"	Horsepower-hour	No
"J"	Joule	Evet
"Wh" ; "wh"	Watt-hour	Evet

Flux density

Unit symbol	Açıklama	OnEk
"ga"	Gauss	Evet
"T"	Tesla	Evet

Kuvvet

Unit symbol	Açıklama	OnEk
"dyn" ; "dy"	Dyne	Evet
"N"	Newton	Evet
"lbf"	Pound-force	No
"pond"	Pond	Evet

Bilgiler

Unit symbol	Açıklama	OnEk
"bit"	Bit	Evet
"byte"	Bayt	Evet

Length and distance

Unit symbol	Açıklama	OnEk
"ang"	Angstrom	Evet
"ell"	Ell	No
"ft"	Ayak	No
"in"	Inç	No
"ly" ; "lightyear"	Light-year	Evet
"m"	Metre	Evet
"mi"	International mile	No
"Nmi"	Nautical mile	No
"parsec" ; "pc"	Parsec	Evet
"Pica" ; "picapt"	Pica point	No
"pica"	Pika	No
"survey_mi"	US survey mile	No
"yd"	Yard	No

Mass and weight

Unit symbol	Açıklama	OnEk
"cwt" ; "shweight"	Short hundredweight	No
"g"	Gram	Evet
"grain"	Grain	No
"lbm"	Pound	No
"ozm"	Ounce	No
"pweight"	Pennyweight	No
"sg"	Slug	No
"stone"	Taş	No
"ton"	Short ton	No
"u"	Unified atomic mass unit	Evet
"uk_cwt" ; "lcwt" ; "hweight"	Long hundredweight	No
"uk_ton" ; "LTON" ; "brton"	Long ton	No

Üs

Unit symbol	Açıklama	OnEk
"HP" ; "h"	Mechanical horsepower	No
"PS"	Pferdestärke or metric horsepower	No
"W" ; "w"	Watt	Evet

Basınç

Unit symbol	Açıklama	OnEk
"atm" ; ("at")⁽¹⁾	Standard atmosphere	Evet
"mmHg"	Millimeter of mercury	Evet
"Pa"	Pascal	Evet
"psi"	Pound per square inch	No
"Torr"	Torr	No

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

Hız

Unit symbol	Açıklama	OnEk
"admkn"	Admiralty knot	No
"kn"	International knot	No
"m/h" ; "m/hr"	Meters per hour	Evet
"m/s" ; "m/sec"	Meters per second	Evet
"mph"	Miles per hour	No

Sıcaklık

Unit symbol	Açıklama	OnEk
"C" ; "cel"	Degree Celsius	No
"F" ; "fah"	Degree Fahrenheit	No
"K" ; "kel"	Kelvin	Evet
"Rank"	Degree Rankine	No
"Reau"	Degree Réaumur	No

Zaman

Unit symbol	Açıklama	OnEk
"day" ; "d"	Gün	No
"hr"	Saat	No
"mn" ; "min"	Dakika	No
"sec" ; "s"	Saniye	Evet
"yr"	Yıl	No

Cilt

Unit symbol	Açıklama	OnEk
"ang3" ; "ang^3"	Cubic angstrom	Evet
"barrel"	Oil barrel	No
"bushel"	US bushel	No
"cup"	US cup	No
"ft3" ; "ft^3"	Cubic foot	No
"gal"	US gallon	No
"Glass"⁽²⁾	Australian glass (200 milliliters)	No
"GRT" ; "regton"	Gross register tonnage	No
"Humpen"⁽²⁾	Humpen (500 milliliters)	No
"in3" ; "in^3"	Cubic inch	No
"l" ; "L" ; "lt"	Liter	Evet
"ly3" ; "ly^3"	Cubic light-year	No
"m3" ; "m^3"	Cubic meter	Evet
"mi3" ; "mi^3"	Cubic international mile	No
"Middy"⁽²⁾	Australian middy (285 milliliters)	No
"MTON"	Measurement ton	No
"Nmi3" ; "Nmi^3"	Cubic nautical mile	No
"oz"	US fluid ounce	No
"Pica3" ; "Pica^3" ; "picapt3" ; "picapt^3"	Cubic pica point	No
"pica3" ; "pica^3"	Cubic pica	No
"pt" ; "us_pt"	US pint	No
"qt"	US quart	No
"Schooner"⁽²⁾	Australian schooner (425 milliliters)	No
"Sixpack"⁽²⁾	Six pack (2 liters)	No
"tbs"	US tablespoon	No
"tsp"	US teaspoon	No
"tspm"	Metric teaspoon	No
"uk_gal"	Imperial gallon	No
"uk_pt"	Imperial pint	No
"uk_qt"	Imperial quart	No
"yd3" ; "yd^3"	Cubic yard	No

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

OnEk	Çarpan
Y (yotta)	10²⁴
Z (zetta)	10²¹
E (exa)	10¹⁸
P (peta)	10¹⁵
T (tera)	10¹²
G (giga)	10⁹
M (mega)	10⁶
k (kilo)	10³
h (hecto)	10²
e (deca)	10¹
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

OnEk	Çarpan
Yi (yobi)	2⁸⁰
Zi (zebi)	2⁷⁰
Ei (exbi)	2⁶⁰
Pi (pebi)	2⁵⁰
Ti (tebi)	2⁴⁰
Gi (gibi)	2³⁰
Mi (mebi)	2²⁰
ki (kibi)	2¹⁰

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

CONVERT Wiki page