ExcelFlux

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

RowA
6Input
7195.583
8391.166
919.5583
Record 1
=EUROCONVERT(A7,"DEM","EUR")

Illustrative output100

See the inputs and instructions for all 3 examples

Worked 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
Microsoft Excel reference