Difference between revisions of "Manuals/calci/CONVERT"

From ZCubes Wiki
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.

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

SUM


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