Formulas and Functions

Chapter 5 Engineering Functions 79
CONVERT
The CONVERT function converts a number from one measurement system to its
corresponding value in another measurement system.
CONVERT(convert-num, from-unit, to-unit)
 convert-num: The number to be converted. convert-num is a number value.
 from-unit: The current unit of the number to be converted. from-unit is a string
value. It must be one of the specied constants.
 to-unit: The new unit of the number to be converted. to-unit is a string value.
It must be one of the specied constants.
Usage Notes
The possible values for  from-unit and to-unit are contained in tables that follow
the examples (“Supported Conversion Units” on page 80). The tables are organized
by category. If the value is entered into a referenced cell, instead of being typed
directly into the function, the quotes included in the tables are not required. Case is
important and must be strictly followed.
Examples
=CONVERT(9, “lbm”, “kg”) returns 4.08233133 (9 pounds is approximately 4.08 kilograms).
=CONVERT (26.2, “mi”, “m”) returns 42164.8128 (26.2 miles is approximately 42,164.8 meters).
=CONVERT(1, “tsp”, “ml”) returns 4.92892159375 (1 teaspoon is approximately 4.9 milliliters).
Related Topics
For related functions and additional information, see:
“Listing of Engineering Functions” on page 72
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41