EUROCONVERT function
Conversion — a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).
Add-in and Automation · Guided Excel example
Where can you use it?
Teams managing specialist Excel workbooks. Check the example requirements when a formula depends on an add-in, local environment or extra setup.
Scenario in the workbook
Convert historical German mark amounts at the fixed rate of 1.95583 DEM per euro.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Input |
| 7 | 195.583 |
| 8 | 391.166 |
| 9 | 19.5583 |
=EUROCONVERT(A7,"DEM","EUR")Illustrative output100
See the inputs and instructions for all 3 examplesWorked examples
Convert historical German mark amounts at the fixed rate of 1.95583 DEM per euro.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A |
|---|---|
| 6 | Input |
| 7 | 195.583 |
| 8 | 391.166 |
| 9 | 19.5583 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =EUROCONVERT(A7,"DEM","EUR") |
100 |
| Record 2 | =EUROCONVERT(A8,"DEM","EUR") |
200 |
| Record 3 | =EUROCONVERT(A9,"DEM","EUR") |
10 |