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

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.

warning

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


Símbolu de la unidá

Descripción

Prefixu

"ang2" ; "ang^2"

Square angstrom

Yes

"ar"

Are

Yes

"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

Yes

"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

Yes

"cal"

International Steam Table calorie

Yes

"e"

erg

Yes

"eV" ; "ev"

Electron volt

Yes

"flb"

Foot-pound

Non

"HPh" ; "hh"

Horsepower-hour

Non

"J"

Xuliu

Yes

"Wh" ; "wh"

Watt-hour

Yes


Flux density

Símbolu de la unidá

Descripción

Prefixu

"ga"

Gauss

Yes

"T"

Tesla

Yes


Fuercia

Símbolu de la unidá

Descripción

Prefixu

"dyn" ; "dy"

Dyne

Yes

"N"

Newton

Yes

"lbf"

Pound-force

Non

"pond"

Pondiu

Yes


Información

Símbolu de la unidá

Descripción

Prefixu

"bit"

Bit

Yes

"byte"

Byte

Yes


Llonxitú y distancia

Símbolu de la unidá

Descripción

Prefixu

"ang"

Angstrom

Yes

"ell"

Ell

Non

"ft"

Foot

Non

"in"

Inch

Non

"ly" ; "lightyear"

Light-year

Yes

"m"

Meter

Yes

"mi"

International mile

Non

"Nmi"

Nautical mile

Non

"parsec" ; "pc"

Parsec

Yes

"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

Yes

"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

Yes

"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"

Watt

Yes


Pressure

Símbolu de la unidá

Descripción

Prefixu

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

Standard atmosphere

Yes

"mmHg"

Milímetru de mercuriu

Yes

"Pa"

Pascal

Yes

"psi"

Pound per square inch

Non

"Torr"

Torr

Non


warning

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

Yes

"m/s" ; "m/sec"

Meters per second

Yes

"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

Yes

"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

Yes

"yr"

Añu

Non


Volume

Símbolu de la unidá

Descripción

Prefixu

"ang3" ; "ang^3"

Cubic angstrom

Yes

"barrel"

Oil barrel

Non

"bushel"

US bushel

Non

"cup"

US cup

Non

"ft3" ; "ft^3"

Cubic foot

Non

"gal"

US gallon

Non

"Glass"(2)

Australian glass (200 milliliters)

Non

"GRT" ; "regton"

Gross register tonnage

Non

"Humpen"(2)

Humpen (500 milliliters)

Non

"in3" ; "in^3"

Cubic inch

Non

"l" ; "L" ; "lt"

Liter

Yes

"ly3" ; "ly^3"

Cubic light-year

Non

"m3" ; "m^3"

Metru cúbicu

Yes

"mi3" ; "mi^3"

Cubic international mile

Non

"Middy"(2)

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"(2)

Australian schooner (425 milliliters)

Non

"Sixpack"(2)

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


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.


Prefixos

Prefixos decimales

Prefixu

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


Prefixos binarios

Prefixu

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


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

Please support us!