<HTML
><HEAD
><TITLE
>CONVERT</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="UP"
TITLE="Reference"
HREF="function-reference.html#AEN1187"><LINK
REL="PREVIOUS"
TITLE="ODDFYIELD"
HREF="r3315.html"><LINK
REL="NEXT"
TITLE="LOG"
HREF="r3446.html"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="r3315.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="r3446.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="AEN3335"
><A
NAME="GNUMERIC-CONVERT"
></A
>CONVERT</A
></H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN3340"
></A
><H2
>Name</H2
>CONVERT&nbsp;--&nbsp;</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN3343"
></A
><H2
>Synopsis</H2
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="SYNOPSIS"
>CONVERT(number,from_unit,to_unit)</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN3345"
></A
><H2
>Description</H2
><P
>CONVERT returns a conversion from one measurement system to another.  For example, you can convert a weight in pounds to a weight in grams.  @number is the value you want to convert, @from_unit specifies the unit of the @number, and @to_unit is the unit for the result.</P
><P
>@from_unit and @to_unit can be any of the following:</P
><P
></P
><P
>Weight and mass:</P
><P
>'g'    Gram</P
><P
>'sg'   Slug</P
><P
>'lbm'  Pound</P
><P
>'u'    U (atomic mass)</P
><P
>'ozm'  Ounce</P
><P
></P
><P
>Distance:</P
><P
>'m'    Meter</P
><P
>'mi'   Statute mile</P
><P
>'Nmi'  Nautical mile</P
><P
>'in'   Inch</P
><P
>'ft'   Foot</P
><P
>'yd'   Yard</P
><P
>'ang'  Angstrom</P
><P
>'Pica' Pica</P
><P
></P
><P
>Time:</P
><P
>'yr'   Year</P
><P
>'day'  Day</P
><P
>'hr'   Hour</P
><P
>'mn'   Minute</P
><P
>'sec'  Second</P
><P
></P
><P
>Pressure:</P
><P
>'Pa'   Pascal</P
><P
>'atm'  Atmosphere</P
><P
>'mmHg' mm of Mercury</P
><P
></P
><P
>Force:</P
><P
>'N'    Newton</P
><P
>'dyn'  Dyne</P
><P
>'lbf'  Pound force</P
><P
></P
><P
>Energy:</P
><P
>'J'    Joule</P
><P
>'e'    Erg</P
><P
>'c'    Thermodynamic calorie</P
><P
>'cal'  IT calorie</P
><P
>'eV'   Electron volt</P
><P
>'HPh'  Horsepower-hour</P
><P
>'Wh'   Watt-hour</P
><P
>'flb'  Foot-pound</P
><P
>'BTU'  BTU</P
><P
></P
><P
>Power:</P
><P
>'HP'   Horsepower</P
><P
>'W'    Watt</P
><P
>Magnetism:</P
><P
>'T'    Tesla</P
><P
>'ga'   Gauss</P
><P
></P
><P
>Temperature:</P
><P
>'C'    Degree Celsius</P
><P
>'F'    Degree Fahrenheit</P
><P
>'K'    Degree Kelvin</P
><P
></P
><P
>Liquid measure:</P
><P
>'tsp'  Teaspoon</P
><P
>'tbs'  Tablespoon</P
><P
>'oz'   Fluid ounce</P
><P
>'cup'  Cup</P
><P
>'pt'   Pint</P
><P
>'qt'   Quart</P
><P
>'gal'  Gallon</P
><P
>'l'    Liter</P
><P
></P
><P
>For metric units any of the following prefixes can be used:</P
><P
>'E'  exa    1E+18</P
><P
>'P'  peta   1E+15</P
><P
>'T'  tera   1E+12</P
><P
>'G'  giga   1E+09</P
><P
>'M'  mega   1E+06</P
><P
>'k'  kilo   1E+03</P
><P
>'h'  hecto  1E+02</P
><P
>'e'  dekao  1E+01</P
><P
>'d'  deci   1E-01</P
><P
>'c'  centi  1E-02</P
><P
>'m'  milli  1E-03</P
><P
>'u'  micro  1E-06</P
><P
>'n'  nano   1E-09</P
><P
>'p'  pico   1E-12</P
><P
>'f'  femto  1E-15</P
><P
>'a'  atto   1E-18</P
><P
></P
><P
>If @from_unit and @to_unit are different types, CONVERT returns #NUM! error. This function is Excel compatible. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN3436"
></A
><H2
>Examples</H2
><P
></P
><P
>CONVERT(3,"lbm","g") equals 1360.7769.</P
><P
>CONVERT(5.8,"m","in") equals 228.3465.</P
><P
>CONVERT(7.9,"cal","J") equals 33.07567.</P
><P
></P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN3443"
></A
><H2
>See also</H2
><P
>      </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="r3315.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="r3446.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
NAME="GNUMERIC-ODDFYIELD"
></A
>ODDFYIELD</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="function-reference.html#AEN1187"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
NAME="GNUMERIC-LOG"
></A
>LOG</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>