CONVERT

CONVERT(number, from_unit, to_unit)

Returns the number in one measurement system converted to another.

number	The number you want to convert.
from_unit	The units to convert the number from.
to_unit	The units to convert the number to.

REMARKS

* For an illustrated example refer to the page under Advanced Functions
* This function allows conversion between the following types of units: weight & mass, distance, time, pressure, force, energy, power. magnetism, temperature and liquid measure.
* Unit names and prefixes are case sensitive.
* If "from_unit" and "to_unit" are not comparable, then #N/A is returned.
* If the unit does not support an abbreviated unit prefix, then #N/A is returned.
* If the unit does not exist, then #N/A is returned. See Example 9.
* If the input data types are incorrect, then #N/A is returned. See Example 8.
* There are also 18 unit prefix abbreviations that allow metric units to be used easily kg = kilogram, mg = microgram.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=CONVERT(1, "lbm", "kg") = 0.454
2	=CONVERT(10, "g", "ozm") = 0.353
3	=CONVERT(68, "F", "C") = 20
4	=CONVERT(10, "in", "cm") = 25.4
5	=CONVERT(10, "yr", "day") = 3652.5
6	=CONVERT(10, "mn", "sec") = 600
7	=CONVERT(CONVERT(5, "ft", "m"), "m", "ft") = 5
8	=CONVERT(10, "kg", "sec") = #N/A
9	=CONVERT(100, "aa", "bb") = #N/A

1 - What is 1 pound converted to kilograms.
2 - What is 10 grams converted to ounces.
3 - What is 68 degrees farenheit converted to degrees celsius.
4 - What is 10 inches converted to centimetres.
5 - What is 10 years converted to days.
6 - What is 10 minutes converted to seconds.
7 - What is 100 feet converted to metres and then converted back to feet.
8 - If the "from_unit" and the "to_unit" are not compatible, then #N/A is returned.
9 - If the "from_unit" or the "to_unit" are not recognised, then #N/A is returned.