<< Click to Display Table of Contents >> EUROCONVERT (convert EU currencies) |
Syntax:
EUROCONVERT(Number, From, To)
Description:
This function can convert the old currencies of countries that are members of the EU (European Union) and have adopted the European currency Euro.
This function can perform three types of conversions:
a) Convert a number from one of these currencies to Euros, e.g., French francs to Euros.
b) Convert a number from Euros to one of these currencies, e.g. Euros to French francs.
c) Convert a number from one of these currencies to another by first converting it to euros and then to the other currency (a method called "triangulation"), e.g., French francs ‑> Euros ‑> Spanish pesetas. Note: This method can lead to rounding errors of up to 0.01.
Number is the number to be converted.
From and To are codes representing the source and target currency (see table below). Use either PM codes or ISO codes.
Note: Microsoft Excel only supports ISO codes. If you want to keep your calculations Excel-compatible, make sure you solely use ISO codes (right column) with this function.
Uppercase and lowercase letters can be mixed.
Country |
PM code |
ISO code |
All euro countries (euro) |
€ |
EUR |
Belgium (franc) |
BF |
BEF |
Germany (mark) |
DM |
DEM |
Estonia (kroon) |
kr |
EEK |
Finland (markka) |
mk |
FIM |
France (franc) |
F |
FRF |
Greece (drachma) |
Dr |
GRD |
Ireland (pound) |
IR£ |
IEP |
Italy (lira) |
L |
ITL |
Latvia (lats) |
Ls |
LVL |
Lithuania (litas) |
Lt |
LTL |
Luxembourg (franc) |
LF |
LUF |
Malta (lira) |
Lm |
MTL |
Netherlands (guilder) |
fl |
NLG |
Austria (schilling) |
öS |
ATS |
Portugal (escudo) |
esc |
PTE |
Slovakia (koruna) |
Sk |
SKK |
Slovenia (tolar) |
SIT |
SIT |
Spain (peseta) |
pts |
ESP |
Example:
EUROCONVERT(100, "DM", "€") converts 100 German marks to Euros. The result is 51.13 (Euro).
EUROCONVERT(100, "DEM", "EUR") does the same, but uses ISO codes. The result is of course identical: 51.13 (Euro).
EUROCONVERT(100, "DEM", "ATS") returns 703.55 (Austrian schillings).