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).
Search JabSto ::




Custom Search