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.

RADIANS

Converts an angle (in degrees) to radians.

* Function is new to Excel 2013.