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)
Syntax
EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])
Parameters
- number: Required. The currency value to convert
- source: Required. A three-letter string (ISO 4217 code) for the source currency
- target: Required. A three-letter string (ISO 4217 code) for the target currency
- full_precision: Optional. TRUE to display all significant digits; FALSE (default) to use currency-specific rounding rules
- triangulation_precision: Optional. An integer ≥ 3 specifying the number of significant digits used for the intermediate euro value when converting between two euro member currencies
Example
=EUROCONVERT(1.20, "DEM", "EUR")