Difference between revisions of "Manuals/calci/CONVERT"
Jump to navigation
Jump to search
Line 35: | Line 35: | ||
|- | |- | ||
− | | Ounce mass | + | | Ounce mass |
| "ozm" | | "ozm" | ||
|} | |} | ||
Line 45: | Line 45: | ||
|- | |- | ||
− | | | + | | Meter |
− | | " | + | | "m" |
|- | |- | ||
− | | | + | | Kilometer |
− | | | + | | "km" |
|- | |- | ||
− | | | + | | Statute mile |
− | | " | + | | "mi" |
|- | |- | ||
− | | | + | | Nautical mile |
− | | | + | | "Nmi" |
|- | |- | ||
− | | | + | | Inch |
− | | " | + | | "in" |
|- | |- | ||
− | | | + | | yard |
− | | " | + | | "yd" |
+ | |||
+ | |- | ||
+ | | Foot | ||
+ | | "ft" | ||
+ | |||
+ | |- | ||
+ | | Angstrom | ||
+ | | "ang" | ||
+ | |||
+ | |- | ||
+ | | Pica(1/72 in.) | ||
+ | | "Pica" | ||
|} | |} | ||
Revision as of 04:39, 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 " "(double quotes).
Weight/Mass | Fu or Tu |
---|---|
Gram | "g" |
Slug | row 2, cell 3 |
"kg" | "sg" |
Pound mass | row 2, cell 3 |
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 |
---|---|
Gram | "g" |
Slug | row 2, cell 3 |
"kg" | "sg" |
Pound mass | row 2, cell 3 |
U(atomic mass unit) | "u" |
Ounce mass) | "ozm" |
Pressure | Fu or Tu |
---|---|
Gram | "g" |
Slug | row 2, cell 3 |
"kg" | "sg" |
Pound mass | row 2, cell 3 |
U(atomic mass unit) | "u" |
Ounce mass) | "ozm" |
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 |