Some of the content in this topic may not be applicable to some languages.
This article describes the formula syntax and usage of the EUROCONVERT function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Description
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.
If this function is not available, and returns the #NAME? error, install and load the Euro Currency Tools Addin.
Install and load the Euro Currency Tools Addin addin
 On the File tab, click Options, and then click AddIns.
 In the Manage list box, select Excel Addins, and then click Go.
 In the AddIns Available list, select the Euro Currency Tools box, and then click OK.
 If necessary, follow the instructions in the setup program.
Syntax
EUROCONVERT(number,source,target,full_precision,triangulation_precision)
The EUROCONVERT function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
 Number Required. The currency value you want to convert, or a reference to a cell containing the value.
 Source Required. A threeletter string, or reference to a cell containing the string, corresponding to the ISO code for the source currency. The following currency codes are available in the EUROCONVERT function:
Country/Region 
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 
Greece 
drachma 
GRD 
Slovenia 
tolar 
SIT 
Euro member states 
euro 
EUR 
 Target Required. A threeletter 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 Required. 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 Excel to 
FALSE 
Display the result with the currencyspecific rounding rules, see the table that follows. Excel uses the calculation precision value 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 Excel uses 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 
0 
2 
FIM 
2 
2 
GRD 
0 
2 
SIT 
2 
2 
EUR 
2 
2 
 Triangulation_precision Required. 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, Excel does not round the intermediate euro value. If you include this argument when converting from a euro member currency to the euro, Excel calculates the intermediate euro value that could then be converted to a euro member currency.
Remarks
 Excel truncates any trailing zeros in the return value.
 If the source ISO code is the same as the target ISO code, Excel returns the original value of the number.
 Invalid parameters return #VALUE.
 This function does not apply a number format.
 This function cannot be used in array formulas.
Examples
Notes
 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 Commission publications about the euro.
 The examples show the resulting value stored in the cell, not the formatted value.
The example may be easier to understand if you copy it to a blank worksheet.
How do I copy an example?
 Select the example in this article. If you are copying the example in Excel Online, copy and paste one cell at a time.
Important: Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 Create a blank workbook or worksheet.
 In the worksheet, select cell A1, and press CTRL+V. If you are working in Excel Online, repeat copying and pasting for each cell in the example.
Important: For the example to work properly, you must paste it into cell A1 of the worksheet.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
After you copy the example to a blank worksheet, you can adapt it to suit your needs.

1 
2 
3 
4 
5 
6 
7 
8 
9 
10 
11 
12 

A 
B 
C 
Amount 
Source 
Target 
1.2 
DEM 
EUR 
1 
FRF 
EUR 
1 
FRF 
EUR 
1 
FRF 
DEM 
1 
FRF 
DEM 
Formula 
Description (Result) 
=EUROCONVERT(A2,B2,C2) 
Converts 1.2 deutsche marks to the equivalent in euros by using a calculation and display precision of 2 decimal places (0.61) 
=EUROCONVERT(A3,B3,C3,TRUE,3) 
Converts 1 franc to the equivalent in euros by using a calculation and display precision of 3 decimal places (0.152) 
=EUROCONVERT(A4,B4,C4,FALSE,3) 
Converts 1 franc to the equivalent in euros by using a calculation and display precision of 2 decimal places (0.15) 
=EUROCONVERT(A5,B5,C5,TRUE,3) 
Converts 1 franc to the equivalent in deutsche marks by using an intermediate calculation precision of 3 and displaying all significant digits (0.29728616) 
=EUROCONVERT(A6,B6,C6,FALSE,3) 
Converts 1 franc to the equivalent in deutsche marks by using an intermediate calculation precision of 3 and a display precision of 2 (0.3). 

Note The trailing zero is truncated.