CONVERT function - Zoho Sheet - Help Guide

CONVERT

Converts the given number from one measurement unit to another.

 

Syntax

 

CONVERT(number; "original_units"; "new_units")

number: The number you want to convert. Eg., 1

original_units: The measurement unit from which you want to convert. Eg., "m"

new_units: The measurement unit to which you want to convert the number. Eg., "mi"

 

property

units

Weight

g (Gram), sg (Slug), lbm (Pound mass), u (Atomic mass), ozm (Ounce mass), stone (Stone), ton (Ton), grain (Grain), pweight (Sampling weight), hweight (Imperial hundredweight), shweight (U.S. hundredweight)

length

m (meter), mi (Statute mile), Nmi (Nautical mile), in (Inch), ft (Foot), yd (Yard), ang (Angstrom), Pica (Pica), ell (Ell), parsec (Parsec)

time

yr (Year), day, hr (Hour), mn (Minute), sec (Second)

pressure

Pa (Pascal), atm (Atom), mmHg (mm of Mercury), Torr (Torr), psi (PSI)

force

N (Newton), dyn (Dyne), pond (Pond)

energy

J (Joule), e (Erg), c (Thermodynamic calorie), cal (Calorie), eV (Electron volt), HPh (Horsepower-Hour), Wh (Watt-Hour), BTU (BTU)

power

W (Watt), HP (Horsepower), PS (Pferdestarke)

field strength

T (Tesla), ga (Gauss)

temperature

C (Degree Celsius), F (Degree Fahrenheit), K (Kelvin), Reau (Degree Reaumur), Rank (Degree Rankine)

volume

l (Liter), tsp (Teaspoon), tbs (Tablespoon), oz (Fluid ounce), cup (Cup), pt (U.S. pint), qt (Quart), gal (Gallon), m3 (Cubic meter), mi3 (Cubic mile), Nmi3 (Cubic nautical mile), in3 (Cubic inch), ft3 (Cubic feet), yd3 (Cubic yard), ang3 (Cubic angstrom), Pica3 (Cubic pica), barrel (U.S. oil barrel), bushel (U.S. bushel), regton (Gross Registered Ton), Schooner, Middy, Glass

area

m2 (Square meters), mi2 (Square miles), Nmi2 (Square nautical miles), in2 (Square inches), ft2 (Square feet), yd2 (Square yards), ang2 (Square angstrom), Pica2 (Square pica), Morgen, ar (Are), acre, ha (Hectare)

speed

m/s (Meters per second), m/h (Meters per hour), mph (Miles per hour), kn (Knot), admkn (Admiralty knot)

 

 

prefix < 1

y (10 -24 ), z (10 -21 ), a (10 -18 ), f (10 -15 ), p (10 -12 ), n (10 -9 ), u (10 -6 ), m (10 -3 ), c (10 -2 ), d (10 -1 )

prefix > 1

e (10 1 ), h (10 2 ), k (10 3 ), M 10 6 ), G (10 9 ), T (10 12 ), P (10 15 ), E (10 18 ), Z (10 21 ), Y (10 24 )

 

Remarks

  • The parameters  original_units  and  new_units  are case-sensitive. For example, APPLE and Apple are treated differently.

  • The prefix values are case-sensitive.


Examples

 

Formula

Result

=CONVERT(1,"m"; "mi")

0.000621371

=CONVERT(0.01; "ton"; "grain")

140000.0544311


Get a hands-on experience of the function in the embedded range below.   



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to l ook for. Commonly occurs in VLOOKUP and similar functions.

  • The given unit does not exist.

  • The original_unit and new_unit belong to different groups.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.

 

Similar Functions