SpreadJS 14
Formula Reference / Formula Functions / Other Functions / EURO
In This Topic
    EURO
    In This Topic

    This function returns the equivalent of one Euro based on the ISO currency code.

    Syntax

    EURO(code)

    Arguments

    The argument is the ISO currency code of certain countries. This function does not convert all currencies; only those Euro member currencies listed here.

    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

    Remarks

    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 string data for the code. Returns numeric data.

    Examples

    EURO(""BEF"")

    See Also