Microsoft Office Tutorials and References
In Depth Information
CONVERT
CONVERT
CONVERT interprets data from one measurement system to another.
=CONVERT(number,from_unit,to_unit)
The CONVERT function is found only if the Analysis Toolpak is installed. In addition it must be
turned on in the Add-Ins from the Tools menu. Notice the conversion examples and how the
formula is structured in Figure 5.9. The conversion tables in Tables 5.1 and 5.2 show the
conversion text that must be used to convert units of measure.
The number to convert.
NUMBER
Measurement unit to convert from.
FROM_UNIT
Measurement unit to convert to.
TO_UNIT
Table 5.1
Conversion Table
Unit Type
From Unit to Unit
Weight and Mass
Gram
“g”
Slug
“sg”
Pound mass
“lbm”
U
“u”
Distance
Meter
“m”
Statute mile
“mi”
Nautical mile
“Nmi”
Inch
“in”
Foot
“ft”
Yard
“yd”
Angstrom
“ang”
Pica(1/72 in.)
“Pica”
Time
Year
“y”
Day
“day”
Hour
“hr”
Minute
“mn”
Second
“sec”
Search JabSto ::




Custom Search