CONVERT function

Convierte un valor d'una unidá de midida al valor correspondiente n'otra unidá de midida. Pon les unidaes de midida direutamente como testu entecomináu o como referencia. Les unidaes de midida especificaes al traviés de los argumentos tienen de coincidir colos símbolos d'unidá almitíos, qu'estremen ente mayúscules y minúscules. Por exemplu, el símbolu de la unidá «newton» ye la «N» mayúscula.

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.

Esta función pue nun ser compatible con otros programes de fueya de cálculu.

Sintaxis

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.

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

Exemplos

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

Área

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

Símbolu de la unidá	Descripción	Prefixu
"ang2" ; "ang^2"	Square angstrom	Sí
"ar"	Are	Sí
"ft2" ; "ft^2"	Square foot	Non
"ha"	Hectare	Non
"in2" ; "in^2"	Square inch	Non
"ly2" ; "ly^2"	Square light-year	Non
"m2" ; "m^2"	Square meter	Sí
"mi2" ; "mi^2"	Square international mile	Non
"Morgen"	Morgen	Non
"Nmi2" ; "Nmi^2"	Square nautical mile	Non
"Pica2" ; "Pica^2" ; "picapt2" ; "picapt^2"	Square pica point	Non
"pica2" ; "pica^2"	Square pica	Non
"uk_acre" ; "acre"	International acre	Non
"us_acre"	US survey acre	Non
"yd2" ; "yd^2"	Square yard	Non

Energy

Símbolu de la unidá	Descripción	Prefixu
"BTU" ; "btu"	British thermal unit	Non
"c"	Thermochemical calorie	Sí
"cal"	International Steam Table calorie	Sí
"e"	erg	Sí
"eV" ; "ev"	Electron volt	Sí
"flb"	Foot-pound	Non
"HPh" ; "hh"	Horsepower-hour	Non
"J"	Xuliu	Sí
"Wh" ; "wh"	Watt-hour	Sí

Flux density

Símbolu de la unidá	Descripción	Prefixu
"ga"	Gauss	Sí
"T"	Tesla	Sí

Fuercia

Símbolu de la unidá	Descripción	Prefixu
"dyn" ; "dy"	Dyne	Sí
"N"	Newton	Sí
"lbf"	Pound-force	Non
"pond"	Pondiu	Sí

Información

Símbolu de la unidá	Descripción	Prefixu
"bit"	Bit	Sí
"byte"	Byte	Sí

Llargor y distancia

Símbolu de la unidá	Descripción	Prefixu
"ang"	Angstrom	Sí
"ell"	Ell	Non
"ft"	Foot	Non
"in"	Inch	Non
"ly" ; "lightyear"	Light-year	Sí
"m"	Metru	Sí
"mi"	International mile	Non
"Nmi"	Nautical mile	Non
"parsec" ; "pc"	Parsec	Sí
"Pica" ; "picapt"	Pica point	Non
"pica"	Pica	Non
"survey_mi"	US survey mile	Non
"yd"	Yard	Non

Mass and weight

Símbolu de la unidá	Descripción	Prefixu
"cwt" ; "shweight"	Short hundredweight	Non
"g"	Gram	Sí
"grain"	Grain	Non
"lbm"	Pound	Non
"ozm"	Ounce	Non
"pweight"	Pennyweight	Non
"sg"	Slug	Non
"stone"	Stone	Non
"ton"	Short ton	Non
"u"	Unidá de masa atómica xunificada	Sí
"uk_cwt" ; "lcwt" ; "hweight"	Long hundredweight	Non
"uk_ton" ; "LTON" ; "brton"	Long ton	Non

Power

Símbolu de la unidá	Descripción	Prefixu
"HP" ; "h"	Mechanical horsepower	Non
"PS"	Pferdestärke or metric horsepower	Non
"W" ; "w"	Vatiu	Sí

Pressure

Símbolu de la unidá	Descripción	Prefixu
"atm" ; ("at")⁽¹⁾	Standard atmosphere	Sí
"mmHg"	Milímetru de mercuriu	Sí
"Pa"	Pascal	Sí
"psi"	Pound per square inch	Non
"Torr"	Torr	Non

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

Velocidá

Símbolu de la unidá	Descripción	Prefixu
"admkn"	Admiralty knot	Non
"kn"	International knot	Non
"m/h" ; "m/hr"	Meters per hour	Sí
"m/s" ; "m/sec"	Meters per second	Sí
"mph"	Miles per hour	Non

Temperatura

Símbolu de la unidá	Descripción	Prefixu
"C" ; "cel"	Grau Celsius	Non
"F" ; "fah"	Grau Fahrenheit	Non
"K" ; "kel"	Kelvin	Sí
"Rank"	Grau Rankine	Non
"Reau"	Grau Réaumur	Non

Tiempu

Símbolu de la unidá	Descripción	Prefixu
"day" ; "d"	Día	Non
"hr"	Hora	Non
"mn" ; "min"	Minutu	Non
"sec" ; "s"	Segundu	Sí
"yr"	Añu	Non

Volume

Símbolu de la unidá	Descripción	Prefixu
"ang3" ; "ang^3"	Cubic angstrom	Sí
"barrel"	Barril de petroleu	Non
"bushel"	US bushel	Non
"cup"	US cup	Non
"ft3" ; "ft^3"	Cubic foot	Non
"gal"	US gallon	Non
"Glass"⁽²⁾	Australian glass (200 milliliters)	Non
"GRT" ; "regton"	Gross register tonnage	Non
"Humpen"⁽²⁾	Humpen (500 milliliters)	Non
"in3" ; "in^3"	Cubic inch	Non
"l" ; "L" ; "lt"	Llitru	Sí
"ly3" ; "ly^3"	Cubic light-year	Non
"m3" ; "m^3"	Metru cúbicu	Sí
"mi3" ; "mi^3"	Cubic international mile	Non
"Middy"⁽²⁾	Australian middy (285 milliliters)	Non
"MTON"	Measurement ton	Non
"Nmi3" ; "Nmi^3"	Cubic nautical mile	Non
"oz"	US fluid ounce	Non
"Pica3" ; "Pica^3" ; "picapt3" ; "picapt^3"	Cubic pica point	Non
"pica3" ; "pica^3"	Cubic pica	Non
"pt" ; "us_pt"	US pint	Non
"qt"	US quart	Non
"Schooner"⁽²⁾	Australian schooner (425 milliliters)	Non
"Sixpack"⁽²⁾	Six pack (2 liters)	Non
"tbs"	US tablespoon	Non
"tsp"	US teaspoon	Non
"tspm"	Metric teaspoon	Non
"uk_gal"	Imperial gallon	Non
"uk_pt"	Imperial pint	Non
"uk_qt"	Imperial quart	Non
"yd3" ; "yd^3"	Cubic yard	Non

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.

Prefixos

Prefixos decimales

Prefixu	Multiplier
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

Prefixos binarios

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

Información téunica

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