This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).
EUROCONVERT(currency,source,target,fullprecision,triangulation)
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.
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.
Accepts numeric and string data for most arguments; the fullprecision argument is a logical value. Returns numeric data.
EUROCONVERT(B5,"DEM","EUR")
EUROCONVERT(R5C2,"DEM","EUR", TRUE, 3)