Microsoft Office Tutorials and References
In Depth Information
Tip 43: Converting Between Measurement Systems
The CONVERT function is even more versatile than it seems. When using metric units, you can apply a
multiplier. In fact, the first example I presented uses a multiplier. The unit abbreviation for the third
argument is for meters. I added the kilo-multiplier ( k) to express the result in kilometers.
In some situations, the CONVERT function requires some creativity. For example, if you need to
convert 100 km/hour into miles/sec, the formula requires two uses of the CONVERT function:
=CONVERT(100,”km”,”mi”)/CONVERT(1,”hr”,”sec”)
The CONVERT function has been significantly enhanced in Excel 2013 and supports dozens of new
measurement units.
If you can’t find a particular unit that works with the CONVERT function, perhaps Excel has another
function that will do the job. Table 43-1 lists some other functions that convert between
measurement units.
Table 43-1: Other Conversion Functions
Function
Description
ARABIC*
Converts an Arabic number to decimal.
BASE*
Converts a decimal number to a specified base.
BIN2DEC
Converts a binary number to decimal.
BIN2OCT
Converts a binary number to octal.
DEC2BIN
Converts a decimal number to binary.
DEC2HEX
Converts a decimal number to hexadecimal.
DEC2OCT
Converts a decimal number to octal.
DEGREES
Converts an angle (in radians) to degrees.
HEX2BIN
Converts a hexadecimal number to binary.
HEX2DEC
Converts a hexadecimal number to decimal.
HEX2OCT
Converts a hexadecimal number to octal.
OCT2BIN
Converts an octal number to binary.
OCT2DEC
Converts an octal number to decimal.
OCT2HEX
Converts an octal number to hexadecimal.