|
|
| Line 411: |
Line 411: |
| | | | |
| | ==References== | | ==References== |
| − | [http://en.wikipedia.org/wiki/Summation SUM] | + | [http://en.wikipedia.org/wiki/Conversion_of_units Units] |
| − | | |
| − | | |
| − | | |
| − | | |
| − | | |
| − | 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.'''
| |
| − | | |
| − | {| id="TABLE1" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | <div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f" | 0.6804
| |
| − | | class="sshl_f" | NaN
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f SelectTD SelectTD" |
| |
| − | <div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |}
| |
Revision as of 05:35, 19 November 2013
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 (syntax error): {\displaystyle " "}
(double quotes).
This function show the result as Error:
- when the input value are incorrect
- when the FU or TU are not exist
- when the units are in not same groups.
Unit names and indications are case-sensitive.
| 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"
|
Example =CONVERT(1.50, "lbm", "kg") is 0.6804
Examples
| Equation
|
n1
|
n2
|
n3
|
SUM
|
| CONVERT(10,"ozm","sg")
|
10
|
ozm
|
sg
|
0.019425668878
|
| CONVERT(30,"lbm","kg")
|
30
|
lbm
|
kg
|
13.60776929
|
| CONVERT(0.5,"mi","m")
|
0.5
|
mi
|
m
|
804.6077
|
| CONVERT(0.002,"km","Nmi")
|
0.002
|
km
|
Nmi
|
0.001079
|
| CONVERT(5,"ft","in")
|
5
|
ft
|
in
|
60
|
| CONVERT(7,"yd","ang")
|
7
|
yd
|
ang
|
64007999999.9
|
| CONVERT(5,"yd","Pica")
|
5
|
yd
|
Pica
|
12959.99
|
| CONVERT(15,"Pa","mmHg")
|
15
|
Pa
|
mmHg
|
0.112509
|
| CONVERT(4, "yr","day")
|
4
|
yr
|
day
|
1461
|
| CONVERT(1.5,"mn","sec")
|
1.5
|
mn
|
sec
|
90
|
| CONVERT(15,"lbf","N")
|
15
|
lbf
|
N
|
66.72333
|
| CONVERT(10,"BTU","J")
|
10
|
BTU
|
J
|
10550.581
|
| CONVERT(15,"W","HP")
|
15
|
W
|
HP
|
0.020115301
|
| CONVERT(45,"T","ga")
|
45
|
T
|
ga
|
450000
|
| CONVERT(90,"F","K")
|
90
|
F
|
K
|
305.3722222
|
| CONVERT(100,"oz","cup")
|
100
|
oz
|
cup
|
12.5
|
| CONVERT(25,"pt","qt")
|
25
|
pt
|
qt
|
62.5
|
See also
References
Units