EUROCONVERT
Converts 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).
User DefinedUser Defined
What it does
Converts currency between Euro members and the Euro.
Syntax
EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])
Arguments
number(number) — Value to convert.source(text) — Source currency ISO code.target(text) — Target currency ISO code.
Examples
Convert DM to Euro
Convert 100 Deutsche Mark to Euro.
FORMULA
=EUROCONVERT(100, "DEM", "EUR")
RESULT
51.13
SAMPLE DATA
| A | |
|---|---|
| 1 | Amount |
| 2 | 100 |