EUROCONVERT

Summary

This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).

Syntax

EUROCONVERT(currency,source,target,fullprecision,triangulation)

Arguments

This function has these arguments:

Argument	Description
currency	Number to convert
source	ISO currency code for the number to convert (see table below)
target	ISO currency code for the result of the conversion (see table below)
fullprecision	[Optional] Logical value representing whether to display the value in full precision or not; if omitted, the value is not displayed in full precision
triangulation	[Optional] Integer greater than or equal to 3 that specifies the number of significant digits to be used for the intermediate Euro value when converting between two Euro member currencies

If triangulation is omitted, the calculation does not round the intermediate Euro value. If it is included when converting from a Euro member currency to the Euro, the calculation finds the intermediate Euro value that could then be converted to a Euro member currency.

Remarks

This function does not convert all currencies; only those Euro member currencies listed in this table.

Country/Region	ISO Currency Code
Belgium	BEF
Luxembourg	LUF
Germany	DEM
Spain	ESP
France	FRF
Ireland	IEP
Italy	ITL
Netherlands	NLG
Austria	ATS
Portugal	PTE
Finland	FIM
Euro member state	EUR

ISO Currency Codes are from ISO 4217, the international standard describing three-letter codes to define the names of currencies. ISO is the nickname for the International Organization for Standardization.The first two letters of the code are the two-letter country codes (ISO 3166) and the third is usually the initial of the currency itself. So BEF is Belgium Franc.

Data Types

Accepts numeric and string data for most arguments; the fullprecision argument is a logical value. Returns numeric data.

Examples

EUROCONVERT(B5,"DEM","EUR")

EUROCONVERT(R5C2,"DEM","EUR", TRUE, 3)