Microsoft Office Tutorials and References

In Depth Information

**Tip 43: Converting Between Measurement Systems**

Converting Between Measurement

Systems

You know the distance from New York to London in miles, but your European office needs the

numbers in kilometers. What’s the conversion factor?

The Excel CONVERT function can convert between a variety of measurements in these categories:

➤ Area

➤ Distance

➤ Energy

➤ Force

➤ Information

➤ Magnetism

➤ Power

➤ Pressure

➤ Speed

➤ Temperature

➤ Time

➤ Volume (or liquid measure)

➤ Weight and mass

The CONVERT function requires three arguments: the value to be converted, the from-unit, and the

to-unit. For example, if cell A1 contains a distance expressed in miles, use this formula to convert

miles to kilometers:

=CONVERT(A1,”mi”,”km”)

The second and third arguments are unit abbreviations, which are listed in the Help system. Some

abbreviations are commonly used, but others aren’t. And, of course, you must use the
exact

abbreviation. Furthermore, the unit abbreviations are case-sensitive, so the following formula returns an error:

=CONVERT(A1,”Mi”,”km”)