Practice free

EUROCONVERT function

EUROCONVERT converts between the euro and currencies that joined it, using the official fixed conversion rates. It needs the Euro Currency Tools add-in turned on and shows #NAME? without it.

Example

=EUROCONVERT(100,"DEM","EUR")

Expected result: n/a Not yet checked in desktop Excel

Syntax

EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])

Arguments in [square brackets] are optional.

number (required)
Amount to convert.
source (required)
Three-letter code of the starting currency.
target (required)
Three-letter code of the target currency.
full_precision (optional)
TRUE for full precision; FALSE or omitted rounds to the currency's norm.
triangulation_precision (optional)
Digits to keep for the intermediate euro step.

Returns: The converted amount using fixed euro conversion rates.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=EUROCONVERT(1,"DEM","EUR") #NAME? DEM to EUR
=EUROCONVERT() #NAME? No argument

Watch out for

  • Only works for the old fixed-rate currencies, not live rates like USD.
  • Without the add-in it shows #NAME?.

Where it works

Excel
EUROCONVERT needs an add-in or a connected service. Not available in this local Excel build; needs the Euro Currency Tools add-in turned on.
Google Sheets
No direct equivalent. Use GOOGLEFINANCE or a rate cell; only fixed legacy rates are relevant.

Part of Add-in and automation functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .