EURO Function (Gnumeric)

• Introduced: First introduction is unknown from the inspected records.
• Documented support: Registered in Gnumeric 1.12.62, in the Financial Functions plugin. No retirement is established.
• Last functioning version: Unverified for this guide; source presence does not certify an application execution.
• Scope and dates: English formulas are shown. Official source snapshots were retained from the October 13–14, 2026 audit. This full guide and its reference calculations were checked on October 15, 2026; no newer source retrieval or native run is implied.

EURO returns the number of legacy national-currency units represented by one euro in Gnumeric’s built-in historical conversion table. For example, EURO(“DEM”) gives 1.95583. It does not download current exchange rates, convert an amount by itself, or provide a general list of all currencies that have ever adopted the euro.

The function-specific help and complete callback provide the product-specific contract.

=EURO(currency)

• currency: Required exact uppercase three-letter code from the pinned lookup table, such as “DEM”, “FRF” or “EUR”. Use quotes for a literal code or refer to a cell containing the code.

The registration was checked alongside the callback; use the exact function name and argument order rather than assuming cross-application equivalence.

Enter code DEM in B2 and an old amount 195.583 in B3. In B5 enter =EURO(B2); the reference constant is 1.95583 marks per euro. In B6 enter =B3/B5; the decoded historical amount is 100 euros. The division is important because the function returns national units per euro, not euros per national unit.

To translate that 100-euro value into French francs using the same fixed table, use =B6*EURO("FRF"), giving 655.957. These are exact-reference calculations from the stored constants before any chosen display rounding or accounting-specific rounding policy.

All outputs below are source-derived independent reference results. Decimal outputs are rounded to twelve places where needed. Quoted codes remain text; numeric examples remain numbers.

The complete inspected code set is ATS, BEF, CYP, DEM, EEK, ESP, EUR, FIM, FRF, GRD, IEP, ITL, LUF, MTL, NLG, PTE, SIT and SKK. The EUR entry is 1. BEF and LUF share 40.3399; that numerical equality does not make the two names the same currency or justify merging records.

A direct conversion from legacy currency A to B can be expressed as amount/EURO(A)*EURO(B). Preserve the original code and amount, and document any rounding performed after the arithmetic. EUROCONVERT is the related conversion function, but its optional precision policy requires separate review; this guide’s division-and-multiplication examples do not claim to reproduce every EUROCONVERT mode.

The callback performs exact case-sensitive string comparisons. Lowercase “dem”, a code with leading or trailing spaces, “USD”, and a code absent from this pinned table return #NUM! according to its error branch. Do not interpret an unsupported code as evidence that a currency does not exist or that its status never changed; it only means the inspected Gnumeric table lacks that exact key.

The source help calls the historical function unlikely to be useful anymore, but the function remains registered in the inspected version. That wording is not retirement evidence. The fixed constants can still be useful for interpreting historical records. For contemporary market rates, use a dated, appropriate exchange-rate source and record its quotation direction; EURO does not update itself to that source. Native text coercion and locale formatting are outside this guide’s source-only checks.

The fixtures use explicit strings or valid numeric arguments and dates. Native blank/text coercions, localized formula entry and display formatting remain unverified; keep missing inputs distinct from intentional zero.

• Pinned worksheet implementation

• Pinned function help

• Complete fixed conversion table

The calculations are an independent reference model, not execution of the full Gnumeric engine, headless application or graphical editor. No exact installed-release behavior, GUI entry, locale handling, import parity or extreme-value outcome is certified beyond the stated source scope. Reproduce a small fixture in the target build before relying on an operational workbook.

DOLLARDE, DOLLARFR.