Difference between revisions of "Manuals/calci/CONVERT"
Jump to navigation
Jump to search
Line 186: | Line 186: | ||
| Watt-hour | | Watt-hour | ||
| "Wh" | | "Wh" | ||
+ | |} | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Power | ||
+ | ! Fu or Tu | ||
+ | |||
+ | |- | ||
+ | | Horse power | ||
+ | | "HP" | ||
+ | |||
+ | |- | ||
+ | | Watt | ||
+ | | "W" | ||
+ | |||
+ | |} | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Magnetism | ||
+ | ! Fu or Tu | ||
+ | |||
+ | |- | ||
+ | | Gauss | ||
+ | | "ga" | ||
+ | |||
+ | |- | ||
+ | | Tesla | ||
+ | | "T" | ||
+ | |||
|} | |} | ||
Revision as of 04:09, 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).
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" |
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
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 |