Difference between revisions of "Manuals/calci/CONVERT"
| Line 7: | Line 7: | ||
==Description== | ==Description== | ||
This function gives the changing the one unit system to other unit system. | 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 <math>" "</math>(double quotes).< | + | 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 <math>" "</math>(double quotes).<\br> |
This function show the result as Error: | This function show the result as Error: | ||
#when the input value are incorrect | #when the input value are incorrect | ||
Revision as of 05:44, 19 November 2013
- is the value in .
- is the units for the value.
- is the units for the result.
is the value in 
.
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).<\br> 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" |
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 |