Microsoft Office Tutorials and References

In Depth Information

**Convert Units of Measurement**

You can find these functions in the Insert Function dialog box under the

Engineering.

Convert Units of Measurement

CONVERT is a really great function that Excel provides. Not surprisingly, it

converts things, or more specifically, it converts measurements. The number

of measurements it converts is truly impressive. The function converts feet

to inches, meters to feet, Fahrenheit to Celsius, pints to liters, horsepower

to watts, and much more. In fact, there are over a dozen categories that

contain dozens of units of measure to convert from and to. The major categories

follow:

✓
Weight and mass

✓
Distance

✓
Time

✓
Pressure

✓
Energy

✓
Power

✓
Temperature

✓
Liquid measure

The function takes three arguments: the value, the “from” unit of measure,

and the “to” unit of measure. As an example, here is the function syntax for

converting 10 gallons to liters: =CONVERT(10,”gal”, “l”). By the way, the

answer is 37.85.

Consult the Excel Help system for a full list of available conversions.

Find the Greatest Common Divisor

and the Least Common Multiple

A
greatest common divisor
is the largest integer that divides evenly into each

number in a set of numbers. In other words, it divides with no remainder. Take

the numbers 5, 10, and 100. The greatest common divisor is 5 because each of

the numbers divided by 5 returns another integer (no decimal portion).