CONVERT Function (Functions in Excel)
Amount To Convert | Converting From | Converting To | Converted Amount | |
1 | in | cm | 2.54 | =CONVERT(C4,D4,E4) |
1 | ft | m | 0.3048 | =CONVERT(C5,D5,E5) |
1 | yd | m | 0.9144 | =CONVERT(C6,D6,E6) |
1 | yr | day | 365.25 | =CONVERT(C8,D8,E8) |
1 | day | hr | 24 | =CONVERT(C9,D9,E9) |
1.5 | hr | mn | 90 | =CONVERT(C10,D10,E10) |
0.5 | mn | sec | 30 | =CONVERT(C11,D11,E11) |
What Does It Do ? |
This function converts a value measure in one type of unit, to the same value expressed |
in a different type of unit, such as Inches to Centimetres. |
Syntax |
=CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo) |
Formatting |
No special formatting is needed. |
Example |
The following table was used by an Import / Exporting company to convert the weight |
and size of packages from old style UK measuring system to European system. |
Pounds | Ounces | Kilograms | |
Weight | 5 | 3 | 2.35301 |
=CONVERT(D28,"lbm","kg")+CONVERT(E28,"ozm","kg") |
Feet | Inches | Metres | |
Height | 12 | 6 | 3.81 |
Length | 8 | 3 | 2.5146 |
Width | 5 | 2 | 1.5748 |
=CONVERT(D34,"ft","m")+CONVERT(E34,"in","m") |
Abbreviations | |||||
This is a list of all the possible abbreviations which can be used to denote measuring systems. | |||||
Weight & Mass | Distance | ||||
Gram | g | Meter | m | ||
Kilogram | kg | Statute mile | mi | ||
Slug | sg | Nautical mile | Nmi | ||
Pound mass | lbm | Inch | in | ||
U (atomic mass) | u | Foot | ft | ||
Ounce mass | ozm | Yard | yd | ||
Angstrom | ang | ||||
Time | Pica (1/72 in.) | Pica | |||
Year | yr | ||||
Day | day | Pressure | |||
Hour | hr | Pascal | Pa | ||
Minute | mn | Atmosphere | atm | ||
Second | sec | mm of Mercury | mmHg | ||
Temperature | Liquid | ||||
Degree Celsius | C | Teaspoon | tsp | ||
Degree Fahrenheit | F | Tablespoon | tbs | ||
Degree Kelvin | K | Fluid ounce | oz | ||
Cup | cup | ||||
Force | Pint | pt | |||
Newton | N | Quart | qt | ||
Dyne | dyn | Gallon | gal | ||
Pound force | lbf | Liter | l | ||
Energy | Power | ||||
Joule | J | Horsepower | HP | ||
Erg | e | Watt | W | ||
Thermodynamic calorie | c | ||||
IT calorie | cal | Magnetism | |||
Electron volt | eV | Tesla | T | ||
Horsepower-hour | HPh | Gauss | ga | ||
Watt-hour | Wh | ||||
Foot-pound | flb | ||||
BTU | BTU | ||||
These characters can be used as a prefix to access further units of measure. | ||||||
Using "c" as a prefix to meters "m" will allow centimetres "cm" to be calculated. | ||||||
Prefix | Multiplier | Abbreviation | Prefix | Multiplier | Abbreviation | |
exa | 1.00E+18 | E | deci | 1.00E-01 | d | |
peta | 1.00E+15 | P | centi | 1.00E-02 | c | |
tera | 1.00E+12 | T | milli | 1.00E-03 | m | |
giga | 1.00E+09 | G | micro | 1.00E-06 | u | |
mega | 1.00E+06 | M | nano | 1.00E-09 | n | |
kilo | 1.00E+03 | k | pico | 1.00E-12 | p | |
hecto | 1.00E+02 | h | femto | 1.00E-15 | f | |
dekao | 1.00E+01 | e | atto | 1.00E-18 | a | |
0 comments:
Post a Comment