Difference between revisions of "Manuals/calci/CONVERT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 12: Line 12:
 
|-
 
|-
 
! Weight/Mass
 
! 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"
 +
|}
 +
 +
{| class="wikitable"
 +
|-
 +
! Distance
 +
! 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"
 +
|}
 +
 +
{| class="wikitable"
 +
|-
 +
! 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"
 +
|}
 +
 +
{| class="wikitable"
 +
|-
 +
! Pressure
 
! Fu or Tu
 
! Fu or Tu
  

Revision as of 03:32, 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
Gram "g"
Slug row 2, cell 3
"kg" "sg"
Pound mass row 2, cell 3
U(atomic mass unit) "u"
Ounce mass) "ozm"
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

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