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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .