CONVERTCORE (Number,FromUnit,ToUnit,DoNotTryConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)
- is the value in to change.
- is the units for the value.
- is the units for the result.
Description
- This function converts one unit system to another unit system.
- Example:To change the length in kilometer unit to standard unit meter.
- and will accept any units which we need to give in " "(double quotes).
This function show the result as Error:
- when the input value are incorrect
- when the and does not exist
- when the units are in not same groups.
Unit names and indications are case-sensitive.
Weight/Mass
|
Fromunit or Tounit
|
Gram
|
"g"
|
Kilo gram
|
"kg"
|
Slug
|
"sg"
|
Pound mass
|
"lbm"
|
U(atomic mass unit)
|
"u"
|
Ounce mass
|
"ozm"
|
Distance
|
Fromunit or Tounit
|
Meter
|
"m"
|
Kilometer
|
"km"
|
Statute mile
|
"mi"
|
Nautical mile
|
"Nmi"
|
Inch
|
"in"
|
yard
|
"yd"
|
Foot
|
"ft"
|
Angstrom
|
"ang"
|
Pica(1/72 in.)
|
"Pica"
|
Time
|
Fromunit or Tounit
|
Year
|
"yr"
|
Day
|
"day"
|
Hour
|
"hr"
|
Minute
|
"mn"
|
Second
|
"sec"
|
Pressure
|
Fromunit or Tounit
|
Pascal
|
"Pa"
|
Atmosphere
|
"atm"
|
mm of Mercury
|
"mmHg"
|
Force
|
Fromunit or Tounit
|
Newton
|
"N"
|
Dyne
|
"dyn"
|
Pound Force
|
"lbf"
|
Energy
|
Fromunit or Tounit
|
Joule
|
"J"
|
Erg
|
"e"
|
IT calorie
|
"cal"
|
Thermodynamic calorie
|
"c"
|
BTU
|
"BTU"
|
Electron volt
|
"eV"
|
Foot pound
|
"flb"
|
Horsepower hour
|
"HPh"
|
Watt-hour
|
"Wh"
|
Kilocalorie
|
"kcal"
|
Power
|
Fromunit or Tounit
|
Horse power
|
"HP"
|
Watt
|
"W"
|
Magnetism
|
Fromunit or Tounit
|
Gauss
|
"ga"
|
Tesla
|
"T"
|
Temperature
|
Fromunit or Tounit
|
Kelvin
|
"K"
|
Degree Celsius
|
"C"
|
Degree Fahrenheit
|
"F"
|
Liquid Measure
|
Fromunit or Tounit
|
Liter
|
"l"
|
Milliliter
|
"ml"
|
Gallon
|
"gal"
|
Quart
|
"qt"
|
U.K.pint
|
"uk_pt"
|
U.S.pint
|
"pt"
|
Cup
|
"cup"
|
Fluid ounce
|
"oz"
|
Teaspoon
|
"tsp"
|
Tablespoon
|
"tbs"
|
Examples
See Also
References
Convert Units