Documentation/Calc Functions/CONVERT OOO

    From The Document Foundation Wiki
    Other languages:


    Function name:

    CONVERT_OOO

    Category:

    Mathematical

    Summary:

    Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the Eurozone, and vice versa. The conversion uses the fixed exchange rates at which the legacy currencies entered the euro.

    Note pin.svg

    Note:
    We recommend using the more flexible EUROCONVERT function for converting between these currencies. For converting between many different units of measurement, use the CONVERT function.

    CONVERT_OOO is not a standardized function and is not portable.

    Syntax:

    CONVERT_OOO(Value; Text1; Text2)

    Returns:

    Returns a real number which is the converted value expressed in the currency specified by the argument Text2.

    Arguments:

    Value is a real number, or a reference to a cell containing that number, that is the amount to be converted (expressed in the currency specified by the argument Text1).

    Text1 is a text string, or a reference to a cell containing a text string, that specifies the currency to be converted from. One of 20 possible case-sensitive strings – "ATS", "BEF", "CYP", "DEM", "EEK", "ESP", "EUR", "FIM", "FRF", "GRD", "IEP", "ITL", "LTL", "LUF", "LVL", "MTL", "NLG", "PTE", "SIT", and "SKK".

    Text2 is a text string, or a reference to a cell containing a text string, that specifies the currency to be converted from. One of 20 possible case-sensitive strings, as listed for Text1.

    • If Value is non-numeric, then CONVERT_OOO reports a #VALUE! error.
    • If either of Text1 or Text2 is not one of the expected strings specifying a valid currency, then CONVERT_OOO reports a #N/A error.
    • One, and only one, of Text1 and Text2 should specify the euro. Therefore, if neither or both are equal to "EUR", then CONVERT_OOO reports a #N/A error.

    Additional details:

    The following table lists the legacy, three-character currency codes recognised by CONVERT_OOO and the fixed conversion rate used for each currency.

    Code Currency Rate
    ATS Austrian schilling 13.7603
    BEF Belgian franc 40.3399
    CYP Cypriot pound 0.585274
    DEM German mark 1.95583
    EEK Estonian kroon 15.6466
    ESP Spanish peseta 166.386
    FIM Finnish markka 5.94573
    FRF French franc 6.55957
    GRD Greek drachma 340.750
    IEP Irish pound 0.787564
    ITL Italian lira 1,936.27
    LTL Lithuanian litas 3.45280
    LUF Luxembourg franc 40.3399
    LVL Latvian lats 0.702804
    MTL Maltese lira 0.429300
    NLG Dutch guilder 2.20371
    PTE Portuguese escudo 200.482
    SIT Slovenian tolar 239.640
    SKK Slovak koruna 30.1260
    • For additional information about the history of the euro, see Wikipedia’s Euro page.
    • The currency codes and conversion rates are read from a configuration file named .../share/registry/main.xcd.

    Examples:

    Formula Description Returns
    =CONVERT_OOO(100; "ATS"; "EUR") Here the function converts 100 Austrian schillings into euros. 7.26728341678597
    =CONVERT_OOO(D1; D2; D3) where cells D1, D2 and D3 contain the number 100, the string "EUR", and the string "DEM" respectively. Here the function converts 100 euros to German marks. 195.583
    =CONVERT_OOO(CONVERT_OOO(100; "FRF"; "EUR"); "EUR"; "ITL") Here 100 French francs are converted to euros, with the result then converted to Italian lire. Conversion between the national currencies is carried out using the process of triangulation via the euro. 29,518.2458606281

    Related LibreOffice functions:

    CONVERT

    EUROCONVERT

    ODF standard:

    None

    Related (or similar) Excel functions:

    None