|
|
Line 1: |
Line 1: |
− | {{Documentation/MasterTOC | + | {{DISPLAYTITLE:CONVERT function}} |
− | |bookid=1234'''
| + | {{Documentation/CalcFunc MathematicalTOC |
− | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
| + | |ShowPrevNext=block |
− | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]]
| + | |PrevPage=Documentation/How_Tos/Calc:_COMBINA_function |
− | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CONVERT_ADD_function | + | |NextPage=Documentation/How_Tos/Calc:_CONVERT_ADD_function |
− | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_COMBINA_function
| + | }}__NOTOC__ |
− | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions | + | |
− | |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions
| + | |
− | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
| + | |
− | | + | |
− | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Trigonometric</div>
| + | |
− | * [[Documentation/How_Tos/Calc:_COS_function|<div style="font-size: 120%;">Cos]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SIN_function|<div style="font-size: 120%;">Sin]]
| + | |
− | * [[Documentation/How_Tos/Calc:_TAN_function|<div style="font-size: 120%;">Tan]]
| + | |
− | * [[Documentation/How_Tos/Calc:_COT_function|<div style="font-size: 120%;">Cot]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ACOS_function|<div style="font-size: 120%;">Acos]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ACOT_function|<div style="font-size: 120%;">Acot]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ASIN_function|<div style="font-size: 120%;">Asin]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ATAN_function|<div style="font-size: 120%;">Atan]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ATAN2_function|<div style="font-size: 120%;">Atan2]]
| + | |
− | * [[Documentation/How_Tos/Calc:_DEGREES_function|<div style="font-size: 120%;">Degrees]]
| + | |
− | * [[Documentation/How_Tos/Calc:_RADIANS_function|<div style="font-size: 120%;">Radians]]
| + | |
− | * [[Documentation/How_Tos/Calc:_PI_function|<div style="font-size: 120%;">Pi]]
| + | |
− | | + | |
− | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Hyperbolic</div>
| + | |
− | * [[Documentation/How_Tos/Calc:_COSH_function|<div style="font-size: 120%;">Cosh]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SINH_function|<div style="font-size: 120%;">Sinh]]
| + | |
− | * [[Documentation/How_Tos/Calc:_TANH_function|<div style="font-size: 120%;">Tanh]]
| + | |
− | * [[Documentation/How_Tos/Calc:_COTH_function|<div style="font-size: 120%;">Coth]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ACOSH_function|<div style="font-size: 120%;">Acosh]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ACOTH_function|<div style="font-size: 120%;">Acoth]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ASINH_function|<div style="font-size: 120%;">Asinh]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ATANH_function|<div style="font-size: 120%;">Atanh]]
| + | |
− | | + | |
− | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Rounding and remainders</div>
| + | |
− | * [[Documentation/How_Tos/Calc:_TRUNC_function|<div style="font-size: 120%;">Trunc]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ROUND_function|<div style="font-size: 120%;">Round]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ROUNDDOWN_function|<div style="font-size: 120%;">Rounddown]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ROUNDUP_function|<div style="font-size: 120%;">Roundup]]
| + | |
− | * [[Documentation/How_Tos/Calc:_CEILING_function|<div style="font-size: 120%;">Ceiling]]
| + | |
− | * [[Documentation/How_Tos/Calc:_FLOOR_function|<div style="font-size: 120%;">Floor]]
| + | |
− | * [[Documentation/How_Tos/Calc:_EVEN_function|<div style="font-size: 120%;">Even]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ODD_function|<div style="font-size: 120%;">Odd]]
| + | |
− | * [[Documentation/How_Tos/Calc:_MROUND_function|<div style="font-size: 120%;">Mround]]
| + | |
− | * [[Documentation/How_Tos/Calc:_INT_function|<div style="font-size: 120%;">Int]]
| + | |
− | * [[Documentation/How_Tos/Calc:_QUOTIENT_function|<div style="font-size: 120%;">Quotient]]
| + | |
− | * [[Documentation/How_Tos/Calc:_MOD_function|<div style="font-size: 120%;">Mod]]
| + | |
− | | + | |
− | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Logarithm/Powers</div>
| + | |
− | * [[Documentation/How_Tos/Calc:_EXP_function|<div style="font-size: 120%;">Exp]]
| + | |
− | * [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]]
| + | |
− | * [[Documentation/How_Tos/Calc:_LOG_function|<div style="font-size: 120%;">Log]]
| + | |
− | * [[Documentation/How_Tos/Calc:_LN_function|<div style="font-size: 120%;">Ln]]
| + | |
− | * [[Documentation/How_Tos/Calc:_LOG10_function|<div style="font-size: 120%;">Log10]]
| + | |
− | | + | |
− | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Bessel functions</div>
| + | |
− | * [[Documentation/How_Tos/Calc:_BESSELI_function|<div style="font-size: 120%;">Besseli]]
| + | |
− | * [[Documentation/How_Tos/Calc:_BESSELJ_function|<div style="font-size: 120%;">Besselj]]
| + | |
− | * [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk]]
| + | |
− | * [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]]
| + | |
− | | + | |
− | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
| + | |
− | * [[Documentation/How_Tos/Calc:_ABS_function|<div style="font-size: 120%;">Abs]]
| + | |
− | * [[Documentation/How_Tos/Calc:_COMBIN_function|<div style="font-size: 120%;">Combin]]
| + | |
− | * [[Documentation/How_Tos/Calc:_COMBINA_function|<div style="font-size: 120%;">Combina]]
| + | |
− | * [[Documentation/How_Tos/Calc:_CONVERT_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Convert]]
| + | |
− | * [[Documentation/How_Tos/Calc:_CONVERT_ADD_function|<div style="font-size: 120%;">Convert Add]]
| + | |
− | * [[Documentation/How_Tos/Calc:_COUNTBLANK_function|<div style="font-size: 120%;">Countblank]]
| + | |
− | * [[Documentation/How_Tos/Calc:_COUNTIF_function|<div style="font-size: 120%;">Countif]]
| + | |
− | * [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ERF_function|<div style="font-size: 120%;">Erf]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ERFC_function|<div style="font-size: 120%;">Erfc]]
| + | |
− | * [[Documentation/How_Tos/Calc:_FACT_function|<div style="font-size: 120%;">Fact]]
| + | |
− | * [[Documentation/How_Tos/Calc:_FACTDOUBLE_function|<div style="font-size: 120%;">Factdouble]]
| + | |
− | * [[Documentation/How_Tos/Calc:_GCD_function|<div style="font-size: 120%;">Gcd]]
| + | |
− | * [[Documentation/How_Tos/Calc:_GCD_ADD_function|<div style="font-size: 120%;">Gcd Add]]
| + | |
− | * [[Documentation/How_Tos/Calc:_GESTEP_function|<div style="font-size: 120%;">Gestep]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ISEVEN_function|<div style="font-size: 120%;">Iseven]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ISODD_function|<div style="font-size: 120%;">Isodd]]
| + | |
− | * [[Documentation/How_Tos/Calc:_LCM_function|<div style="font-size: 120%;">Lcm]]
| + | |
− | * [[Documentation/How_Tos/Calc:_LCM_ADD_function|<div style="font-size: 120%;">Lcm Add]]
| + | |
− | * [[Documentation/How_Tos/Calc:_MULTINOMIAL_function|<div style="font-size: 120%;">Multinomial]]
| + | |
− | * [[Documentation/How_Tos/Calc:_PRODUCT_function|<div style="font-size: 120%;">Product]]
| + | |
− | * [[Documentation/How_Tos/Calc:_RAND_function|<div style="font-size: 120%;">Rand]]
| + | |
− | * [[Documentation/How_Tos/Calc:_RANDBETWEEN_function|<div style="font-size: 120%;">Randbetween]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SIGN_function|<div style="font-size: 120%;">Sign]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SQRT_function|<div style="font-size: 120%;">Sqrt]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SUBTOTAL_function|<div style="font-size: 120%;">Subtotal]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SUM_function|<div style="font-size: 120%;">Sum]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]]
| + | |
− | * [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]]
| + | |
− | }}__TOC__ | + | |
| | | |
| == CONVERT == | | == CONVERT == |
Line 100: |
Line 12: |
| <tt>'''CONVERT(value; currency1; currency2)'''</tt> | | <tt>'''CONVERT(value; currency1; currency2)'''</tt> |
| : <tt>'''value'''</tt> is the amount of the currency to be converted. | | : <tt>'''value'''</tt> is the amount of the currency to be converted. |
− | : <tt>'''currency1'''</tt> and <tt>'''currency2'''</tt> are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"), as shown in the table below. The rates (shown per Euro) were set by the European Commission. The legacy currencies were replaced by the Euro in 2002. | + | : <tt>'''currency1'''</tt> and <tt>'''currency2'''</tt> are the currency units to convert from and to, respectively. These must be text, the official abbreviation for the currency (for example, "EUR"), as shown in the table below. The rates (shown per Euro) were set by the European Commission. The legacy currencies were replaced by the Euro in 2002. |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | | {| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" |