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




Custom Search