CONVERT

Excel Functions

Convert measurement units

Syntax

EXCEL

=CONVERT(number, from_unit, to_unit)

Arguments

Parameter	Description
`number`	The numeric value to convert.
`from_unit`	The starting units for number.
`to_unit`	The ending units for the result.

Return Value

A number in the new measurement system

Details

The CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, gallons into liters, and for many other unit conversions. The formulas below use the CONVERT function to convert yards to meters, Celsius to Fahrenheit, gallons to liters, and square meters to square yards: To round the results returned by CONVERT, nest CONVERT inside the ROUND function: The tables below show the units available to the CONVERT function in each category. In all cases, Unit can be used for either from_unit or to_unit in the same category. Use these units to convert between different measures of weight and mass. This is useful for recipes, shipping calculations, and scientific applications. For example:

Examples

The formulas below use the CONVERT function to convert yards to meters, Celsius to Fahrenheit, gallons to liters, and square meters to square yards:

EXCEL

=CONVERT(100,"yd","m") // returns 91.44
=CONVERT(22,"C","F") // returns 71.6
=CONVERT(1,"gal","l") // returns 3.79
=CONVERT(100,"m2","ft2") // returns 1076.39

Examples

To round the results returned by CONVERT, nest CONVERT inside the ROUND function:

EXCEL

=ROUND(CONVERT(100,"yd","m"),0) // yards to meters, returns 91
=ROUND(CONVERT(5,"mi","km"),1) // miles to kilometers, returns 8.0
=ROUND(CONVERT(150,"lbm","kg"),1) // pounds to kilograms, returns 68.0

Mass

Use these units to convert between different measures of weight and mass. This is useful for recipes, shipping calculations, and scientific applicatio

EXCEL

=CONVERT(150,"lbm","kg") // pounds to kilograms, returns 68.04
=CONVERT(500,"g","ozm") // grams to ounces, returns 17.64
=CONVERT(1,"stone","lbm") // stone to pounds, returns 14

Distance

These units allow you to perform conversions related to length and distance. For example:

EXCEL

=CONVERT(5,"mi","km") // miles to kilometers, returns 8.05
=CONVERT(6,"ft","m") // feet to meters, returns 1.83
=CONVERT(100,"cm","in") // centimeters to inches, returns 39.37

Time

Convert between different units of time with these options. For example:

EXCEL

=CONVERT(2.5,"hr","min") // hours to minutes, returns 150
=CONVERT(90,"mn","hr") // minutes to hours, returns 1.5
=CONVERT(1,"day","sec") // days to seconds, returns 86400

Pressure

Use these units for pressure-related conversions, commonly needed in engineering and scientific contexts. For example:

EXCEL

=CONVERT(1,"atm","psi") // atmospheres to PSI, returns 14.70
=CONVERT(30,"psi","Pa") // PSI to pascals, returns 206842.7188
=CONVERT(760,"mmHg","atm") // mmHg to atmospheres, returns 1