EUROCONVERT

Office Components Spreadsheet Function

EUROCONVERT

See Also

Some of the content in this topic may not be applicable to some languages.

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). The currencies available for conversion are those of European Union (EU) members that have adopted the euro. The function uses fixed conversion rates that are established by the EU.

Syntax

EUROCONVERT(number,source,target,full_precision,triangulation_precision)

Number   is the currency value you want to convert, or a reference to a cell containing the value.

Source   is a three-letter string, or reference to a cell containing the string, corresponding to the International Organization for Standardization (ISO) code for the source currency. The following currency codes are available in the EUROCONVERT function:

Country Basic unit of currency ISO code
Belgium franc BEF
Luxembourg franc LUF
Germany deutsche mark DEM
Spain peseta ESP
France franc FRF
Ireland pound IEP
Italy lira ITL
Netherlands guilder NLG
Austria schilling ATS
Portugal escudo PTE
Finland markka FIM
Euro member states euro EUR

Target   is a three-letter string, or cell reference, corresponding to the ISO code of the currency to which you want to convert the number. See the previous Source table for the ISO codes.

Full_precision   is a logical value (TRUE or FALSE), or an expression that evaluates to a value of TRUE or FALSE, that specifies how to display the result.

Use If you want to
FALSE Display the result with the currency-specific rounding rules (see the table that follows).The calculation precision value is used to calculate the result and the display precision value to display the result. FALSE is the default if the full_precision argument is omitted.
TRUE Display the result with all significant digits resulting from the calculation.

The following table shows the currency specific rounding rules, that is, how many decimal places are used to calculate a currency's conversion and display the result.

ISO code Calculation precision Display precision
BEF 0 0
LUF 0 0
DEM 2 2
ESP 0 0
FRF 2 2
IEP 2 2
ITL 0 0
NLG 2 2
ATS 2 2
PTE 1 2
FIM 2 2
EUR 2 2

Triangulation_precision   is an integer equal to or greater than 3 that specifies the number of significant digits to be used for the intermediate euro value when converting between two euro member currencies. If you omit this argument, the intermediate euro value is not rounded. If you include this argument when converting from a euro member currency to the euro, the spreadsheet calculates the intermediate euro value that could then be converted to a euro member currency.

Remarks

  • Trailing zeros in the return value are truncated.
  • If the source ISO code is the same as the target ISO code, the original value of the number is returned.
  • Invalid parameters return #VALUE.
  • This function does not apply a number format.

Examples

These examples assume conversion rates of 1 euro = 6.55957 French francs and 1.95583 deutsche marks. The EUROCONVERT function uses the current rates established by the EU. Microsoft will update the function if the rates change. To get full information about the rules and the rates currently in effect, see the European Union publications about the euro.

The examples show the resulting value stored in the cell, not the formatted value.

EUROCONVERT(1.20,"DEM","EUR") equals 0.61 euro. Because neither full_precision nor triangulation_precision are specified, the result uses the calculation precision for the euro, which is 2 decimal places.

EUROCONVERT(1,"FRF","EUR",TRUE,3) equals 0.152 euro. When converting to euros, if full_precision is TRUE, the result has the precision specified by triangulation_precision.

EUROCONVERT(1,"FRF","EUR",FALSE,3) equals 0.15 euro. When converting to euros, if full_precision is FALSE, the result uses the calculation precision for the euro, which is 2 decimal places.

EUROCONVERT(1,"FRF","DEM",TRUE,3) equals 0.29728616 DM. Because triangulation_precision is 3, the intermediate euro value is rounded to three places. Because full_precision is TRUE, the resulting deutsche mark value is stored with all significant digits.

EUROCONVERT(1,"FRF","DEM",FALSE,3) equals 0.30 DM. Because triangulation_precision is 3, the intermediate euro value is rounded to three places. Because full_precision is FALSE, the resulting deutsche mark value is rounded to the calculation precision for the deutsche mark, which is 2 decimal places.