SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / EUROCONVERT
In This Topic
    EUROCONVERT
    In This Topic

    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