Manuals/calci/CONVERT

From ZCubes Wiki
Revision as of 04:44, 19 November 2013 by Abin (talk | contribs) (→‎Description)
Jump to navigation Jump to search
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
Year "yr"
Day "day"
Hour "hr"
Minute "mn"
Second "sec"
Pressure Fu or Tu
Pascal "Pa"
Atmosphere "atm"
mm of Mercury "mmHg"

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