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)

எண் சோதனைக்குரிய எண்.

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.


பரப்பு

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

விளக்கம்

Prefix

"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

விளக்கம்

Prefix

"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

விளக்கம்

Prefix

"ga"

Gauss

ஆம்

"T"

Tesla

ஆம்


Force

Unit symbol

விளக்கம்

Prefix

"dyn" ; "dy"

Dyne

ஆம்

"N"

Newton

ஆம்

"lbf"

Pound-force

இல்லை

"pond"

Pond

ஆம்


தகவல்

Unit symbol

விளக்கம்

Prefix

"bit"

Bit

ஆம்

"byte"

Byte

ஆம்


Length and distance

Unit symbol

விளக்கம்

Prefix

"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

விளக்கம்

Prefix

"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

இல்லை


திறன்

Unit symbol

விளக்கம்

Prefix

"HP" ; "h"

Mechanical horsepower

இல்லை

"PS"

Pferdestärke or metric horsepower

இல்லை

"W" ; "w"

Watt

ஆம்


Pressure

Unit symbol

விளக்கம்

Prefix

"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

விளக்கம்

Prefix

"admkn"

Admiralty knot

இல்லை

"kn"

International knot

இல்லை

"m/h" ; "m/hr"

Meters per hour

ஆம்

"m/s" ; "m/sec"

Meters per second

ஆம்

"mph"

Miles per hour

இல்லை


Temperature

Unit symbol

விளக்கம்

Prefix

"C" ; "cel"

Degree Celsius

இல்லை

"F" ; "fah"

Degree Fahrenheit

இல்லை

"K" ; "kel"

Kelvin

ஆம்

"Rank"

Degree Rankine

இல்லை

"Reau"

Degree Réaumur

இல்லை


நேரம்

Unit symbol

விளக்கம்

Prefix

"day" ; "d"

நாள்

இல்லை

"hr"

மணி

இல்லை

"mn" ; "min"

நிமிடம்

இல்லை

"sec" ; "s"

விநாடிகள்

ஆம்

"yr"

ஆண்டு

இல்லை


தொகுதி

Unit symbol

விளக்கம்

Prefix

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


Prefixes

Decimal prefixes

Prefix

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

Prefix

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


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

Please support us!