EUROCONVERT (convert EU currencies)

<< 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).