Difference between revisions of "Manuals/calci/CONVERT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 75: Line 75:
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|}
 
|}
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 

Revision as of 03:46, 19 November 2013


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