Difference between revisions of "Manuals/calci/CONVERT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 144: Line 144:
 
|  "lbf"
 
|  "lbf"
  
 +
|}
 +
 +
{| class="wikitable"
 +
|-
 +
! Energy
 +
! Fu or Tu
 +
 +
|-
 +
| Joule
 +
|  "J"
 +
 +
|-
 +
| Erg
 +
| "e"
 +
 +
|-
 +
| IT calorie 
 +
| "cal"
 +
 +
|-
 +
| Thermodynamic calorie
 +
| "c"
 +
 +
|-
 +
| BTU
 +
| "BTU"
 +
 +
|-
 +
| Electron volt
 +
| "eV"
 +
 +
|-
 +
| Foot pound
 +
| "flb"
 +
 +
|-
 +
| Horsepower hour
 +
| "HPh"
 +
 +
|-
 +
| Watt-hour
 +
|  "Wh"
 
|}
 
|}
  

Revision as of 05:02, 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle " "} (double quotes).

Weight/Mass Fu or Tu
Gram "g"
Kilo gram "kg"
Slug "sg"
Pound mass "lbm"
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"
Force Fu or Tu
Newton "N"
Dyne "dyn"
Pound Force "lbf"
Energy Fu or Tu
Joule "J"
Erg "e"
IT calorie "cal"
Thermodynamic calorie "c"
BTU "BTU"
Electron volt "eV"
Foot pound "flb"
Horsepower hour "HPh"
Watt-hour "Wh"

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