|
|
| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">''' '''</font></font></font>
| |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">CONVERT</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">N</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">, </font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">FU</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">TU</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
| |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Where 'N' is the value in 'FU” to convert, 'FU' is the units for number and 'TU' is the units for the result. </font></font></font>
| + | CONVERT |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="49%" |
| |
| − | Weight and Mass
| |
| − | ! width="51%" |
| |
| − | FU or TU
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | Ounce mass
| |
| − | | width="51%" |
| |
| − | “ozm”
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Pound mass</font></font>
| |
| − | | width="51%" |
| |
| − | “ibm”
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | Slug
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">sg” </font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | U
| |
| − | | width="51%" |
| |
| − | “u”
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Gram</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">g”</font></font>
| |
| − | |}
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Distance</font></font>
| |
| − | ! width="52%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Inch</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">in”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Statute mile</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">mi”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Nautical mile</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">nmi”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Yard</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">yd”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Pica(1/72 in.)</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">pica”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Meter</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">m”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Angstrom</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">ang”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Foot</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">ft”</font></font>
| |
| − | |}
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Time</font></font>
| |
| − | ! width="51%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Second</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">sec”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Minute</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">mn”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Hour</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">hr”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Day</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">day”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Year</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">yr”</font></font>
| |
| − | |}
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Pressure</font></font>
| |
| − | ! width="51%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">mm of Mercury</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">mmhg”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Pascal</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">pa” (or “p”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Atmosphere</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">atm” (or “at”)</font></font>
| |
| − | |}
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Force</font></font>
| |
| − | ! width="51%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Pound force</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">lbf”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Dyne</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">dyn” (or “dy”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Newton</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">N”</font></font>
| |
| − | |}
| |
| − | | |
| − | <br />
| |
| − | | |
| − | <br />
| |
| | | | |
| − | : {| width="100%" border="1" cellpadding="4"
| + | Where 'N' is the value in 'FU” to convert, 'FU' is the units for number and 'TU' is the units for the result. |
| − | |- valign="top"
| |
| − | ! width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Energy</font></font>
| |
| − | ! width="51%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">IT calorie</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">cal”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Erg</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">e”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Thermodynamic calorie</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">c”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Joule</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">J”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">BTU</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">BTU” (or “btu”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Electron volt</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">eV” (or “ev”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Foot-pound</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">fib”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Horsepower-hour</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">HPH” (or “hh”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="49%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Watt-hour</font></font>
| |
| − | | width="51%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">WH”(or “wh”)</font></font>
| |
| − | |}
| |
| | | | |
| − | <br />
| |
| | | | |
| − | <br />
| + | *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. |
| | | | |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Power</font></font>
| |
| − | ! width="52%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Horsepower</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">HP” (or “h”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Watt</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">W” (or “w”)</font></font>
| |
| − | |}
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Magnetism</font></font>
| |
| − | ! width="52%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Gauss</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">ga”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Tesla</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">T”</font></font>
| |
| − | |}
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Temperature</font></font>
| |
| − | ! width="52%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Kelvin</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">K” (or “kel”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Degree Celsius</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">C” (or “cel”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Degree Fahrenheit</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">F” (or “fah”)</font></font>
| |
| − | |}
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | : {| width="100%" border="1" cellpadding="4"
| |
| − | |- valign="top"
| |
| − | ! width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Liquid measure</font></font>
| |
| − | ! width="52%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">FU or TU</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Liter</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">l” (or “lt”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Galon</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">gal”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Quart</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">qt”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">U.K. pint</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">uk_pt”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">U.S. pint</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">pt” (or “us_pt”)</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Cup</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">cup”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Fluid ounce</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">oz”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Tablespoon</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">tbs”</font></font>
| |
| − | |- valign="top"
| |
| − | | width="48%" |
| |
| − | <font face="Arial, sans-serif"><font size="2">Teaspoon</font></font>
| |
| − | | width="52%" |
| |
| − | “<font face="Arial, sans-serif"><font size="2">tsp”</font></font>
| |
| − | |}
| |
| − |
| |
| − | <br />
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">CONVERT shows an error value when input data are incorrect.</font></font></font>
| |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">Unit must be there in this function, otherwise it shows an error value. </font></font></font>
| |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">Whenever the units are in different groups, CONVERT shows error value. </font></font></font>
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| | | | |
| | CONVERT | | CONVERT |
| | | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
| |
| − |
| |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">CONVERT(N, FU,TU)</font></font></font>
| |
| − |
| |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=CONVERT(1.50, "lbm", "kg") is 0.6804</nowiki></font></font></font>
| |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=CONVERT(2.5, "ft", "sec") shows NAN(error) value.</nowiki></font></font></font>
| + | Lets see an example |
| | | | |
| − | </div>
| + | CONVERT(N, FU,TU) |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
| − | ----
| |
| − | <div id="5SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"> </font></font></font>
| |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''This function converts a number from one measurement system to another system.'''</font></font></font>
| + | =CONVERT(1.50, "lbm", "kg") is 0.6804 |
| | | | |
| − | </div>
| + | =CONVERT(2.5, "ft", "sec") shows NAN(error) value. |
| − | ----
| + | Syntax |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| + | Remarks |
| | + | Examples |
| | + | Description |
| | + | '''This function converts a number from one measurement system to another system.''' |
| | | | |
| | {| id="TABLE1" class="SpreadSheet blue" | | {| id="TABLE1" class="SpreadSheet blue" |
