The Excel EUROCONVERT function converts a number to or from the euro — or between two former euro-zone currencies via euro triangulation — using the fixed legacy conversion rates. It is supplied by the optional Euro Currency Tools add-in and must be enabled before it will work.
Syntax
| Argument | Description | |
|---|---|---|
number | Required | The value to convert. |
source_currency | Required | Three-letter ISO code of the currency you are converting from — "EUR" or a former euro-zone currency such as "DEM", "FRF", "ITL", "ESP". |
target_currency | Required | Three-letter ISO code of the currency you are converting to. |
full_precision | Optional | FALSE (or omitted) applies the currency-specific rounding rules; TRUE keeps the full unrounded result. |
triangulation_precision | Optional | An integer ≥ 3 giving the precision of the intermediate euro value when converting between two non-euro currencies. Omit when one side is the euro. |
How to use it
EUROCONVERT was built for the changeover period when national currencies were being retired in favour of the euro. It only knows the fixed, legally-defined conversion rates of the original euro-zone currencies — it is not a live exchange-rate tool and cannot convert USD, GBP, JPY, or any currency that never had a fixed euro rate.
Converting to or from the euro is a single step:
Converting between two former national currencies uses triangulation: the value is converted to euro first, then to the target currency.
You must enable the add-in first. Go to File → Options → Add-ins → Manage: Excel Add-ins → Go and tick Euro Currency Tools. Until it is loaded, the formula returns a #NAME? error because Excel does not recognise the function.
Try it: interactive demo
Pick a EUROCONVERT example to see the formula and its result.
Practice workbook
Frequently asked questions
Do I need an add-in to use EUROCONVERT?
#NAME?.Can EUROCONVERT convert dollars, pounds, or other live currencies?
STOCKHISTORY / currency data types in Microsoft 365, a Power Query web pull, or an online FX service.What does the triangulation_precision argument do?
triangulation_precision (an integer of 3 or more) sets how many digits the intermediate euro value keeps before the second step. Omit it when one side of the conversion is already the euro.Why does EUROCONVERT give a #NAME? error?
#VALUE!.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class