Difference between revisions of "Manuals/calci/EUROCONVERT"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
=EUROCONVERT(num, src, target, FP, TP)= | =EUROCONVERT(num, src, target, FP, TP)= | ||
− | *where <math>num</math>is the currency value to convert | + | *where <math>num</math> is the currency value to convert |
− | *<math>src</math>a three letter string or code of source currency | + | *<math>src</math> is a three letter string or code of source currency |
− | *<math>target</math>a three letter string or code of target currency | + | *<math>target</math> is a three letter string or code of target currency |
*<math>FP</math>(Full precision) is a logical value TRUE or FALSE that specifies how to display the result | *<math>FP</math>(Full precision) is a logical value TRUE or FALSE that specifies how to display the result | ||
*<math>TP</math>(Triangular precision) is an integer for rounding the intermediate euro value | *<math>TP</math>(Triangular precision) is an integer for rounding the intermediate euro value | ||
Line 28: | Line 28: | ||
EUROCONVERT(1,"ATS","FRF",FALSE,2) ''returns 0.45'' | EUROCONVERT(1,"ATS","FRF",FALSE,2) ''returns 0.45'' | ||
− | |||
*The <math>src</math> and <math>target</math> currency codes for 13 member countries of European Union can be used from the following code table - | *The <math>src</math> and <math>target</math> currency codes for 13 member countries of European Union can be used from the following code table - | ||
Line 114: | Line 113: | ||
|} | |} | ||
+ | == See Also == | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/DOLLARDE | DOLLARDE]] | *[[Manuals/calci/DOLLARDE | DOLLARDE]] | ||
*[[Manuals/calci/DOLLARFR | DOLLARFR]] | *[[Manuals/calci/DOLLARFR | DOLLARFR]] | ||
== Reference == | == Reference == | ||
+ | |||
*[http://en.wikipedia.org/wiki/Euro Euro] | *[http://en.wikipedia.org/wiki/Euro Euro] |
Revision as of 18:01, 20 December 2013
EUROCONVERT(num, src, target, FP, TP)
- where is the currency value to convert
- is a three letter string or code of source currency
- is a three letter string or code of target currency
- (Full precision) is a logical value TRUE or FALSE that specifies how to display the result
- (Triangular precision) is an integer for rounding the intermediate euro value
EUROCONVERT()
- converts a number to euros
- converts a number from euros to a euro member currency
- converts a number from one euro currency to another with triangular precision
Description
EUROCONVERT(num, src, target, FP, TP)
For Example,
1)TO convert currency of 'France' to 'Euros', following function can be used -
EUROCONVERT(5,"FRF","EUR",TRUE) returns 0.7622450861870519
2)TO convert currency of 'Austria' to 'Euros', following function can be used -
EUROCONVERT(1,"ATS","EUR") returns 0.07
3)2)TO convert currency of 'Austria' to currency of 'France', following function can be used -
EUROCONVERT(1,"ATS","FRF",FALSE,2) returns 0.45
- The and currency codes for 13 member countries of European Union can be used from the following code table -
Country | Basic Unit of Currency | !ISO Code |
---|---|---|
Austria | schilling | ATS |
Belgium | franc | BEF |
Finland | markka | FIM |
France | franc | FRF |
Germany | deutsche mark | DEM |
Greece | drachma | GRD |
Ireland | pound | IEP |
Italy | lira | ITL |
Luxembourg | franc | LUF |
Netherlands | guilder | NLG |
Portugal | escudo | PTE |
Slovenia | tolar | SIT |
Spain | peseta | ESP |
Euro member states | euro | EUR |
- can be a logical value TRUE(or 1) or FALSE(or 0). If argument is TRUE(or 1), Calci displays all significant digits.
- If is omitted, Calci assumes it as FALSE(or 0) and uses default precision.
- is the triangular precision integer value >equal;3 that specifies the number of significant digits to be used for converting intermediate euro value, while converting between two euro member currencies.
- If and codes are same, Calci returns the original value.
- If any argument is invalid, Calci displays a #NULL error message.