<< Click to Display Table of Contents >> EUROCONVERT (convert EU currencies)

Syntax:

EUROCONVERT(Number, From, To)

Description:

This function can convert the old currencies of all EU member states that have joined the monetary union, i.e., have introduced the single currency euro.

You can use this function to perform the following types of conversions:

a) Convert an amount from one of these currencies into euros, e.g., German Deutsche Mark (DM) into euros.

b) Convert an amount from euros into one of these currencies, e.g., euros into DM.

c) Convert an amount from one of these currencies into another by first converting it into euros and then into the other currency (a method called "triangulation"), e.g., Spanish pesetas ‑> euros ‑> DM. Note: This method can lead to rounding errors of up to 0.01.

Number is the amount 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 for this function. If you want your calculations to be Excel-compatible, ensure that you only use ISO codes (right column) for the currency codes.

The codes are not case-sensitive.

Example:

EUROCONVERT(100, "DM", "€") converts 100 DM (German marks) into euros. The result is €51.13.

EUROCONVERT(100, "DEM", "EUR") does the same, but uses ISO codes. The result is of course identical: 51.13 (euros).

EUROCONVERT(100, "DEM", "ATS") returns 703.55 (Austrian schillings).