SpreadJS Documentation
EUROCONVERT
SpreadJS Documentation > Formula Reference > Formula Functions > EUROCONVERT

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)

See Also