Difference between revisions of "Manuals/calci/CONVERT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 35: Line 35:
  
 
|-
 
|-
| Ounce mass)
+
| Ounce mass
 
| "ozm"
 
| "ozm"
 
|}
 
|}
Line 45: Line 45:
  
 
|-
 
|-
| Gram
+
| Meter
| "g"
+
| "m"
  
 
|-
 
|-
| Slug
+
| Kilometer
| row 2, cell 3
+
| "km"
  
 
|-
 
|-
| "kg"
+
| Statute mile
| "sg"
+
| "mi"
  
 
|-
 
|-
| Pound mass
+
| Nautical mile
| row 2, cell 3
+
| "Nmi"
  
 
|-
 
|-
| U(atomic mass unit)
+
| Inch
| "u"
+
| "in"
  
 
|-
 
|-
| Ounce mass)
+
| yard
| "ozm"
+
| "yd"
 +
 
 +
|-
 +
| Foot
 +
| "ft"
 +
 
 +
|-
 +
| Angstrom
 +
| "ang"
 +
 
 +
|-
 +
| Pica(1/72 in.)
 +
| "Pica"
 
|}
 
|}
  

Revision as of 03: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

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