Difference between revisions of "Manuals/calci/CONVERT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | <div style="font-size:30px">'''CONVERT(n,fu,tu)'''</div><br/> | ||
| + | |||
| + | *<math>n</math> is the value in <math>fu</math>. | ||
| + | *<math>fu</math> is the units for the value. | ||
| + | *<math>tu</math>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). | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! 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" | ||
| + | |} | ||
| + | |||
| + | ==Examples== | ||
| + | |||
| + | {| id="TABLE3" class="SpreadSheet blue" | ||
| + | |- class="even" | ||
| + | !Equation | ||
| + | | n1 | ||
| + | | n2 | ||
| + | | n3 | ||
| + | | SUM | ||
| + | |- class="odd" | ||
| + | |SUM(1,2,3) | ||
| + | | 1 | ||
| + | | 2 | ||
| + | | 3 | ||
| + | | 6 | ||
| + | |- class="even" | ||
| + | | SUM(5,-9,45) | ||
| + | | 5 | ||
| + | | -9 | ||
| + | | 45 | ||
| + | | 41 | ||
| + | |- class="odd" | ||
| + | | SUM(A1:A3) | ||
| + | | CELL A1 | ||
| + | | CELL A2 | ||
| + | | CELL A3 | ||
| + | | A1+A2+A3 | ||
| + | |- class="even" | ||
| + | |||
| + | |} | ||
| + | |||
| + | ==See also== | ||
| + | |||
| + | *[[Manuals/calci/AVERAGE| AVERAGE]] | ||
| + | *[[Manuals/calci/PRODUCT| PRODUCT]] | ||
| + | |||
| + | ==References== | ||
| + | [http://en.wikipedia.org/wiki/Summation SUM] | ||
Revision as of 04:28, 19 November 2013
CONVERT(n,fu,tu)
- 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 " "(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" |
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 |