Difference between revisions of "Manuals/calci/CONVERT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''CONVERT( | + | <div style="font-size:30px">'''CONVERT(Number,Fromunit,Tounit)'''</div><br/> |
| − | *<math> | + | *<math>Number</math> is the value in <math>Fromunit</math>. |
| − | *<math> | + | *<math>Fromunit</math> is the units for the value. |
| − | *<math> | + | *<math>Tounit</math>is the units for the result. |
==Description== | ==Description== | ||
*This function converts one unit system to another unit system. | *This function converts one unit system to another unit system. | ||
*Example:To change the length in kilometer unit to standard unit meter. | *Example:To change the length in kilometer unit to standard unit meter. | ||
| − | *<math> | + | *<math>Fromunit</math> and <math>Tounit</math> will accept any units which we need to give in <math>" "</math>(double quotes). <br/> |
This function show the result as Error: | This function show the result as Error: | ||
#when the input value are incorrect | #when the input value are incorrect | ||
| − | #when the <math> | + | #when the <math>Fromunit</math> and <math>Tounit</math> does not exist |
#when the units are in not same groups. | #when the units are in not same groups. | ||
| Line 20: | Line 20: | ||
|- | |- | ||
! Weight/Mass | ! Weight/Mass | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 50: | Line 50: | ||
|- | |- | ||
! Distance | ! Distance | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 92: | Line 92: | ||
|- | |- | ||
! Time | ! Time | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 119: | Line 119: | ||
|- | |- | ||
! Pressure | ! Pressure | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 138: | Line 138: | ||
|- | |- | ||
! Force | ! Force | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 157: | Line 157: | ||
|- | |- | ||
! Energy | ! Energy | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 199: | Line 199: | ||
|- | |- | ||
! Power | ! Power | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 214: | Line 214: | ||
|- | |- | ||
! Magnetism | ! Magnetism | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 229: | Line 229: | ||
|- | |- | ||
! Temperature | ! Temperature | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 248: | Line 248: | ||
|- | |- | ||
! Liquid Measure | ! Liquid Measure | ||
| − | ! | + | ! Fromunit or Tounit |
|- | |- | ||
| Line 298: | Line 298: | ||
|- class="even" | |- class="even" | ||
!Equation | !Equation | ||
| − | ! | + | ! Number |
| − | ! | + | ! Fromunit |
| − | ! | + | ! Tounit |
! Result | ! Result | ||
|- class="odd" | |- class="odd" | ||
Revision as of 05:34, 18 April 2014
CONVERT(Number,Fromunit,Tounit)
- is the value in .
- is the units for the value.
- is the units for the result.
is the value in 
.
is the units for the result.Description
- This function converts one unit system to another unit system.
- Example:To change the length in kilometer unit to standard unit meter.
- and will accept any units which we need to give in Failed to parse (syntax error): {\displaystyle " "}
(double quotes).
This function show the result as Error:
- when the input value are incorrect
- when the and does not exist
- when the units are in not same groups.
Unit names and indications are case-sensitive.
| Weight/Mass | Fromunit or Tounit |
|---|---|
| Gram | "g" |
| Kilo gram | "kg" |
| Slug | "sg" |
| Pound mass | "lbm" |
| U(atomic mass unit) | "u" |
| Ounce mass | "ozm" |
| Distance | Fromunit or Tounit |
|---|---|
| Meter | "m" |
| Kilometer | "km" |
| Statute mile | "mi" |
| Nautical mile | "Nmi" |
| Inch | "in" |
| yard | "yd" |
| Foot | "ft" |
| Angstrom | "ang" |
| Pica(1/72 in.) | "Pica" |
| Time | Fromunit or Tounit |
|---|---|
| Year | "yr" |
| Day | "day" |
| Hour | "hr" |
| Minute | "mn" |
| Second | "sec" |
| Pressure | Fromunit or Tounit |
|---|---|
| Pascal | "Pa" |
| Atmosphere | "atm" |
| mm of Mercury | "mmHg" |
| Force | Fromunit or Tounit |
|---|---|
| Newton | "N" |
| Dyne | "dyn" |
| Pound Force | "lbf" |
| Energy | Fromunit or Tounit |
|---|---|
| Joule | "J" |
| Erg | "e" |
| IT calorie | "cal" |
| Thermodynamic calorie | "c" |
| BTU | "BTU" |
| Electron volt | "eV" |
| Foot pound | "flb" |
| Horsepower hour | "HPh" |
| Watt-hour | "Wh" |
| Power | Fromunit or Tounit |
|---|---|
| Horse power | "HP" |
| Watt | "W" |
| Magnetism | Fromunit or Tounit |
|---|---|
| Gauss | "ga" |
| Tesla | "T" |
| Temperature | Fromunit or Tounit |
|---|---|
| Kelvin | "K" |
| Degree Celsius | "C" |
| Degree Fahrenheit | "F" |
| Liquid Measure | Fromunit or Tounit |
|---|---|
| Liter | "l" |
| Milliliter | "ml" |
| Gallon | "gal" |
| Quart | "qt" |
| U.K.pint | "uk_pt" |
| U.S.pint | "pt" |
| Cup | "cup" |
| Fluid ounce | "oz" |
| Teaspoon | "tsp" |
| Tablespoon | "tbs" |
For Example, =CONVERT(1.50, "lbm", "kg") is 0.6804
Examples
| Equation | Number | Fromunit | Tounit | Result |
|---|---|---|---|---|
| CONVERT(10,"ozm","sg") | 10 | ozm | sg | 0.019425668878 |
| CONVERT(30,"lbm","kg") | 30 | lbm | kg | 13.60776929 |
| CONVERT(0.5,"mi","m") | 0.5 | mi | m | 804.6077 |
| CONVERT(0.002,"km","Nmi") | 0.002 | km | Nmi | 0.001079 |
| CONVERT(5,"ft","in") | 5 | ft | in | 60 |
| CONVERT(7,"yd","ang") | 7 | yd | ang | 64007999999.9 |
| CONVERT(5,"yd","Pica") | 5 | yd | Pica | 12959.99 |
| CONVERT(15,"Pa","mmHg") | 15 | Pa | mmHg | 0.112509 |
| CONVERT(4, "yr","day") | 4 | yr | day | 1461 |
| CONVERT(1.5,"mn","sec") | 1.5 | mn | sec | 90 |
| CONVERT(15,"lbf","N") | 15 | lbf | N | 66.72333 |
| CONVERT(10,"BTU","J") | 10 | BTU | J | 10550.581 |
| CONVERT(15,"W","HP") | 15 | W | HP | 0.020115301 |
| CONVERT(45,"T","ga") | 45 | T | ga | 450000 |
| CONVERT(90,"F","K") | 90 | F | K | 305.3722222 |
| CONVERT(100,"oz","cup") | 100 | oz | cup | 12.5 |
| CONVERT(25,"pt","qt") | 25 | pt | qt | 62.5 |