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.

構文

CONVERT(Number; FromUnit; ToUnit)

数値は、変換される数字です。

変換元単位は、変換元の単位です。

ToUnitは変換が行われる単位です。両方の単位は同じ種類である必要があります。

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.

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

背景

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	いいえ

エネルギー

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"	Gauss	はい
"T"	Tesla	はい

力

Unit symbol	概要	局番
"dyn" ; "dy"	Dyne	はい
"N"	Newton	はい
"lbf"	Pound-force	いいえ
"pond"	Pond	はい

情報

Unit symbol	概要	局番
"bit"	Bit	はい
"byte"	バイト型	はい

Length and distance

Unit symbol	概要	局番
"ang"	Angstrom	はい
"ell"	Ell	いいえ
"ft"	フィート	いいえ
"in"	インチ	いいえ
"ly" ; "lightyear"	Light-year	はい
"m"	メートル	はい
"mi"	International mile	いいえ
"Nmi"	Nautical mile	いいえ
"parsec" ; "pc"	Parsec	はい
"Pica" ; "picapt"	Pica point	いいえ
"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"	石	いいえ
"ton"	Short ton	いいえ
"u"	Unified atomic mass unit	はい
"uk_cwt" ; "lcwt" ; "hweight"	Long hundredweight	いいえ
"uk_ton" ; "LTON" ; "brton"	Long ton	いいえ

累乗

Unit symbol	概要	局番
"HP" ; "h"	Mechanical horsepower	いいえ
"PS"	Pferdestärke or metric horsepower	いいえ
"W" ; "w"	Watt	はい

圧力

Unit symbol	概要	局番
"atm" ; ("at")⁽¹⁾	Standard atmosphere	はい
"mmHg"	Millimeter of mercury	はい
"Pa"	Pascal	はい
"psi"	Pound per square inch	いいえ
"Torr"	Torr	いいえ

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"⁽²⁾	Australian glass (200 milliliters)	いいえ
"GRT" ; "regton"	Gross register tonnage	いいえ
"Humpen"⁽²⁾	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"⁽²⁾	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"⁽²⁾	Australian schooner (425 milliliters)	いいえ
"Sixpack"⁽²⁾	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	いいえ

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

局番	乗数表記
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

局番	乗数表記
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