Navigation:  Formula Reference > Spreadsheet Formula Functions >

CONVERT

Previous pageReturn to chapter overviewNext page

 

This function converts a number from one measurement system to its equivalent in another measurement system.

Syntax

CONVERT(number,from-unit,to-unit)

Arguments

This function has these arguments:

Argument

Description

number

Numeric value to convert

from-unit

Convertible units (see table below) of numeric value to convert

to-unit

Convertible units (see table below) of desired result

Remarks

In this context a measurement system is a set of units for different types of measurements. This function converts a number with one set of units to a number in different set of units.

An error value is returned if the convertible units (from-unit and to-unit) are invalid or are from different categories of unit types (different tables below).

The following tables list the convertible units by their unit type:

Weight and Mass Unit Type

Convertible Units

Gram

"g"

Slug

"sg"

Pound Mass

"lbm"

U

"u"

Ounce Mass

"ozm"

 

Distance Unit Type

Convertible Units

Meter

"m"

Statute mile

"mi"

Nautical mile

"Nmi"

Inch

"in"

Foot

"ft"

Yard

"yd"

Angstrom

"ang"

Pica (1/72 in.)

"Pica"

 

Time Unit Type

Convertible Units

Year

"yr"

Day

"day"

Hour

"hr"

Minute

"mn"

Second

"sec"

 

Pressure Unit Type

Convertible Units

Pascal

"Pa"

Atmosphere

"atm"

mm of Mercury

"mmHg"

 

Force Unit Type

Convertible Units

Newton

"N"

Dyne

"dyn"

Pound force

"lbf"

 

Energy Unit Type

Convertible Units

Joule

"J"

Erg

"e"

Thermodynamic calorie

"c"

IT calorie

"cal"

Electron volt

"eV"

Horsepower-hour

"Hph"

Watt-hour

"Wh"

Foot-pound

"flb"

BTU

"BTU"

 

Power Unit Type

Convertible Units

Horsepower

"HP"

Watt

"W"

 

Magnetism Unit Type

Convertible Units

Tesla

"T"

Gauss

"ga"

 

Temperature Unit Type

Convertible Units

Degree Celsius

"C"

Degree Fahrenheit

"F"

Degree Kelvin

"K"

 

Liquid Measure Unit Type

Convertible Units

Teaspoon

"tsp"

Tablespoon

"tbs"

Fluid ounce

"oz"

Cup

"cup"

U.S. pint

"pt"

U.K. pint

"uk_pt"

Quart

"qt"

Gallon

"gal"

Liter

"l"

Data Types

Accepts numeric and string data. Returns numeric data.

Examples

CONVERT(68,"F","C")

 

See Also

DEC2OCT

HEX2OCT

OCT2BIN