Difference between revisions of "Manuals/calci/EURO"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
For Example, | For Example, | ||
| − | 1)To find out the currency conversion value of '1 Euro' to 'DEM', use the following function - | + | 1)To find out the currency conversion value of '1 Euro' to Germany's currency'DEM', use the following function - <br> |
| − | EURO("DEM") ''returns '1.95583' | + | EURO("DEM") ''returns '1.95583'. |
| − | 2)To find out the currency conversion value of '1 Euro' to 'BEF', use the following function - | + | 2)To find out the currency conversion value of '1 Euro' to Belgium's currency 'BEF', use the following function - <br> |
| − | EURO("BEF") ''returns '40.3399' | + | EURO("BEF") ''returns '40.3399'. |
| + | |||
| + | 3)To find out the currency conversion value of '1 Euro' to Greece's currency 'GRD', use the following function - <br> | ||
| + | EURO("GRD") ''returns '340.75'. | ||
| − | |||
| − | |||
*The currency codes for 13 member countries of European Union can be used from the following code table - | *The currency codes for 13 member countries of European Union can be used from the following code table - | ||
| Line 67: | Line 68: | ||
*[[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 19:36, 9 March 2017
EURO(CountryCode)
- is a three letter string or code of target country's currency.
is a three letter string or code of target country's currency.
EURO()
- Gives the currency conversion value of "1 Euro" to another European member country's currency specified with country code.
Description
EURO(CountryCode)
For Example,
1)To find out the currency conversion value of '1 Euro' to Germany's currency'DEM', use the following function -
EURO("DEM") returns '1.95583'.
2)To find out the currency conversion value of '1 Euro' to Belgium's currency 'BEF', use the following function -
EURO("BEF") returns '40.3399'.
3)To find out the currency conversion value of '1 Euro' to Greece's currency 'GRD', use the following function -
EURO("GRD") returns '340.75'.
- The 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 |
- should be entered in double quotes (e.g. "FIM").
Related Videos
See Also
Reference