In this article
EUROCONVERT converts between the euro and former national currencies (DEM, FRF, ITL …) at the fixed 1999-2002 rates. It needs the Euro Currency Tools add-in and is only useful for historical data.
Advertisement
Syntax
=EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])| Argument | What it means |
|---|---|
number |
Amount |
source, target |
ISO codes, e.g. “DEM”, “EUR” |
Examples
Example 1
=EUROCONVERT(A2,B2,C2)Result: 51.13. See the worked example table below for more cases.
EUROCONVERT in practice
Where you will use it
- Restating pre-2002 European accounts
- Historical price comparisons
- Old templates
Worked example
| Amount | From | To | Formula | Result |
|---|---|---|---|---|
| 100 | DEM | EUR | =EUROCONVERT(A2,B2,C2) | 51.13 |
| 1000 | FRF | EUR | =EUROCONVERT(A3,B3,C3) | 152.45 |
| 50 | EUR | ITL | =EUROCONVERT(A4,B4,C4) | 96813.5 |
Not calculated here (needs the Euro Currency Tools add-in). Results at the official fixed rates: 100 DEM = 51.13 EUR, 1000 FRF = 152.45 EUR, 50 EUR = 96,813.5 ITL.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| #NAME? | Enable File > Options > Add-ins > Euro Currency Tools |
| Modern rates | For today's rates use STOCKHISTORY or a currency data type |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong