Manuals/calci/CONVERT
CONVERT(N, FU,TU)
Where 'N' is the value in 'FU” to convert, 'FU' is the units for number and 'TU' is the units for the result.
Weight and Mass
FU or TU
Ounce mass
“ozm”
Pound mass
“ibm”
Slug
“sg”
U
“u”
Gram
“g”
Distance
FU or TU
Inch
“in”
Statute mile
“mi”
Nautical mile
“nmi”
Yard
“yd”
Pica(1/72 in.)
“pica”
Meter
“m”
Angstrom
“ang”
Foot
“ft”
Time
FU or TU
Second
“sec”
Minute
“mn”
Hour
“hr”
Day
“day”
Year
“yr”
Pressure
FU or TU
mm of Mercury
“mmhg”
Pascal
“pa” (or “p”)
Atmosphere
“atm” (or “at”)
Force
FU or TU
Pound force
“lbf”
Dyne
“dyn” (or “dy”)
Newton
“N”
Energy
FU or TU
IT calorie
“cal”
Erg
“e”
Thermodynamic calorie
“c”
Joule
“J”
BTU
“BTU” (or “btu”)
Electron volt
“eV” (or “ev”)
Foot-pound
“fib”
Horsepower-hour
“HPH” (or “hh”)
Watt-hour
“WH”(or “wh”)
Power
FU or TU
Horsepower
“HP” (or “h”)
Watt
“W” (or “w”)
Magnetism
FU or TU
Gauss
“ga”
Tesla
“T”
Temperature
FU or TU
Kelvin
“K” (or “kel”)
Degree Celsius
“C” (or “cel”)
Degree Fahrenheit
“F” (or “fah”)
Liquid measure
FU or TU
Liter
“l” (or “lt”)
Galon
“gal”
Quart
“qt”
U.K. pint
“uk_pt”
U.S. pint
“pt” (or “us_pt”)
Cup
“cup”
Fluid ounce
“oz”
Tablespoon
“tbs”
Teaspoon
“tsp”
- CONVERT shows an error value when input data are incorrect.
- Unit must be there in this function, otherwise it shows an error value.
- Whenever the units are in different groups, CONVERT shows error value.
CONVERT
Lets see an example,
CONVERT(N, FU,TU)
=CONVERT(1.50, "lbm", "kg") is 0.6804
=CONVERT(2.5, "ft", "sec") shows NAN(error) value.
This function converts a number from one measurement system to another system.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 0.6804 | NaN | ||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
