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.


Синтаксис

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


Примеры

=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

Описание

Префикс

"ang2" ; "ang^2"

Square angstrom

Да

"ar"

Are

Да

"ft2" ; "ft^2"

Square foot

Нет

"ha"

Hectare

Нет

"in2" ; "in^2"

Square inch

Нет

"ly2" ; "ly^2"

Square light-year

Нет

"m2" ; "m^2"

Square meter

Да

"mi2" ; "mi^2"

Square international mile

Нет

"Morgen"

Morgen

Нет

"Nmi2" ; "Nmi^2"

Square nautical mile

Нет

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

Square pica point

Нет

"pica2" ; "pica^2"

Square pica

Нет

"uk_acre" ; "acre"

International acre

Нет

"us_acre"

US survey acre

Нет

"yd2" ; "yd^2"

Square yard

Нет


Energy

Unit symbol

Описание

Префикс

"BTU" ; "btu"

British thermal unit

Нет

"c"

Thermochemical calorie

Да

"cal"

International Steam Table calorie

Да

"e"

erg

Да

"eV" ; "ev"

Electron volt

Да

"flb"

Foot-pound

Нет

"HPh" ; "hh"

Horsepower-hour

Нет

"J"

Joule

Да

"Wh" ; "wh"

Watt-hour

Да


Flux density

Unit symbol

Описание

Префикс

"ga"

Гаусс

Да

"T"

Tesla

Да


Force

Unit symbol

Описание

Префикс

"dyn" ; "dy"

Dyne

Да

"N"

Newton

Да

"lbf"

Pound-force

Нет

"pond"

Pond

Да


Information

Unit symbol

Описание

Префикс

"bit"

Bit

Да

"byte"

Byte

Да


Length and distance

Unit symbol

Описание

Префикс

"ang"

Angstrom

Да

"ell"

Ell

Нет

"ft"

Foot

Нет

"in"

Дюйм

Нет

"ly" ; "lightyear"

Light-year

Да

"m"

Meter

Да

"mi"

International mile

Нет

"Nmi"

Nautical mile

Нет

"parsec" ; "pc"

Parsec

Да

"Pica" ; "picapt"

Pica point

Нет

"pica"

Pica

Нет

"survey_mi"

US survey mile

Нет

"yd"

Yard

Нет


Mass and weight

Unit symbol

Описание

Префикс

"cwt" ; "shweight"

Short hundredweight

Нет

"g"

Gram

Да

"grain"

Grain

Нет

"lbm"

Pound

Нет

"ozm"

Ounce

Нет

"pweight"

Pennyweight

Нет

"sg"

Slug

Нет

"stone"

Stone

Нет

"ton"

Short ton

Нет

"u"

Unified atomic mass unit

Да

"uk_cwt" ; "lcwt" ; "hweight"

Long hundredweight

Нет

"uk_ton" ; "LTON" ; "brton"

Long ton

Нет


Power

Unit symbol

Описание

Префикс

"HP" ; "h"

Mechanical horsepower

Нет

"PS"

Pferdestärke or metric horsepower

Нет

"W" ; "w"

Watt

Да


Pressure

Unit symbol

Описание

Префикс

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

Standard atmosphere

Да

"mmHg"

Millimeter of mercury

Да

"Pa"

Pascal

Да

"psi"

Pound per square inch

Нет

"Torr"

Torr

Нет


warning

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


Скорость

Unit symbol

Описание

Префикс

"admkn"

Admiralty knot

Нет

"kn"

International knot

Нет

"m/h" ; "m/hr"

Meters per hour

Да

"m/s" ; "m/sec"

Meters per second

Да

"mph"

Miles per hour

Нет


Температура

Unit symbol

Описание

Префикс

"C" ; "cel"

Degree Celsius

Нет

"F" ; "fah"

Degree Fahrenheit

Нет

"K" ; "kel"

Kelvin

Да

"Rank"

Degree Rankine

Нет

"Reau"

Degree Réaumur

Нет


Время

Unit symbol

Описание

Префикс

"day" ; "d"

День

Нет

"hr"

Час

Нет

"mn" ; "min"

Минута

Нет

"sec" ; "s"

Секунда

Да

"yr"

Год

Нет


Объём

Unit symbol

Описание

Префикс

"ang3" ; "ang^3"

Cubic angstrom

Да

"barrel"

Oil barrel

Нет

"bushel"

US bushel

Нет

"cup"

US cup

Нет

"ft3" ; "ft^3"

Cubic foot

Нет

"gal"

US gallon

Нет

"Glass"(2)

Australian glass (200 milliliters)

Нет

"GRT" ; "regton"

Gross register tonnage

Нет

"Humpen"(2)

Humpen (500 milliliters)

Нет

"in3" ; "in^3"

Cubic inch

Нет

"l" ; "L" ; "lt"

Liter

Да

"ly3" ; "ly^3"

Cubic light-year

Нет

"m3" ; "m^3"

Cubic meter

Да

"mi3" ; "mi^3"

Cubic international mile

Нет

"Middy"(2)

Australian middy (285 milliliters)

Нет

"MTON"

Measurement ton

Нет

"Nmi3" ; "Nmi^3"

Cubic nautical mile

Нет

"oz"

US fluid ounce

Нет

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

Cubic pica point

Нет

"pica3" ; "pica^3"

Cubic pica

Нет

"pt" ; "us_pt"

US pint

Нет

"qt"

US quart

Нет

"Schooner"(2)

Australian schooner (425 milliliters)

Нет

"Sixpack"(2)

Six pack (2 liters)

Нет

"tbs"

US tablespoon

Нет

"tsp"

US teaspoon

Нет

"tspm"

Metric teaspoon

Нет

"uk_gal"

Imperial gallon

Нет

"uk_pt"

Imperial pint

Нет

"uk_qt"

Imperial quart

Нет

"yd3" ; "yd^3"

Cubic yard

Нет


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.


Префиксы

Decimal prefixes

Префикс

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

Префикс

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


Техническая информация

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

Пожалуйста, поддержите нас!