CONVERT(n,fu,tu)
- is the value in .
- is the units for the value.
- is the units for the result.
Description
This function gives the changing the one unit system to other unit system.
Example:To change the length in kilometer unit to standard unit meter, Here N is the value to which we want to covert from FU to TU. Also FU and TU will accept any units which we need to give in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle " "}
(double quotes).
Weight/Mass
|
Fu or Tu
|
Gram
|
"g"
|
Kilo gram
|
"kg"
|
Slug
|
"sg"
|
Pound mass
|
"lbm"
|
U(atomic mass unit)
|
"u"
|
Ounce mass
|
"ozm"
|
Distance
|
Fu or Tu
|
Meter
|
"m"
|
Kilometer
|
"km"
|
Statute mile
|
"mi"
|
Nautical mile
|
"Nmi"
|
Inch
|
"in"
|
yard
|
"yd"
|
Foot
|
"ft"
|
Angstrom
|
"ang"
|
Pica(1/72 in.)
|
"Pica"
|
Time
|
Fu or Tu
|
Year
|
"yr"
|
Day
|
"day"
|
Hour
|
"hr"
|
Minute
|
"mn"
|
Second
|
"sec"
|
Pressure
|
Fu or Tu
|
Pascal
|
"Pa"
|
Atmosphere
|
"atm"
|
mm of Mercury
|
"mmHg"
|
Force
|
Fu or Tu
|
Newton
|
"N"
|
Dyne
|
"dyn"
|
Pound Force
|
"lbf"
|
Energy
|
Fu or Tu
|
Joule
|
"J"
|
Erg
|
"e"
|
IT calorie
|
"cal"
|
Thermodynamic calorie
|
"c"
|
BTU
|
"BTU"
|
Electron volt
|
"eV"
|
Foot pound
|
"flb"
|
Horsepower hour
|
"HPh"
|
Watt-hour
|
"Wh"
|
Power
|
Fu or Tu
|
Horse power
|
"HP"
|
Watt
|
"W"
|
Magnetism
|
Fu or Tu
|
Gauss
|
"ga"
|
Tesla
|
"T"
|
Temperature
|
Fu or Tu
|
Kelvin
|
"K"
|
Degree Celsius
|
"C"
|
Degree Fahrenheit
|
"F"
|
Liquid Measure
|
Fu or Tu
|
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
Equation
|
n1
|
n2
|
n3
|
SUM
|
SUM(1,2,3)
|
1
|
2
|
3
|
6
|
SUM(5,-9,45)
|
5
|
-9
|
45
|
41
|
SUM(A1:A3)
|
CELL A1
|
CELL A2
|
CELL A3
|
A1+A2+A3
|
See also
References
SUM
CONVERT
Where 'N' is the value in 'FU” to convert, 'FU' is the units for number and 'TU' is the units for the result.
- 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.
Syntax
Remarks
Examples
Description
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
|
|
|
|
|