Financial
Excel 2007 (Compatibility)
◉ 17 views
=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). 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 Add-in. Install and load the Euro Currency Tools Add-in add-in
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel for iPadExcel for iPhoneExcel for Android tabletsExcel for Android phones
=EUROCONVERT(number,source,target,full_precision,triangulation_precision)
Hover argument names in the table for details.
Output typeNumber
Popularity12 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =EUROCONVERT() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | The currency value you want to convert, or a reference to a cell containing the value. |
source |
Text | Required | A three-letter 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: |
target |
Text | Required | 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 |
Logical | 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. |
triangulation_precision |
Number | 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. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
Amount |
B2 |
Source |
C2 |
Target |
A3 |
1.20 |
B3 |
DEM |
C3 |
EUR |
A4 |
1.00 |
B4 |
FRF |
C4 |
EUR |
A5 |
1.00 |
B5 |
FRF |
C5 |
EUR |
A6 |
1.00 |
B6 |
FRF |
C6 |
DEM |
A7 |
1.00 |
B7 |
FRF |
C7 |
DEM |
A8 |
Amount |
B8 |
Source |
C8 |
Target |
A9 |
1.20 |
B9 |
DEM |
C9 |
EUR |
A10 |
1.00 |
B10 |
FRF |
C10 |
EUR |
A11 |
1.00 |
B11 |
FRF |
C11 |
EUR |
A12 |
1.00 |
B12 |
FRF |
C12 |
DEM |
A13 |
1.00 |
B13 |
FRF |
C13 |
DEM |
Converts 1.2 deutsche marks to the equivalent in euros by using a calculation and display precision of 2 decimal places (0.61)
=EUROCONVERT(A2,B2,C2)
Result:
0.61
Converts 1 franc to the equivalent in euros by using a calculation and display precision of 3 decimal places (0.152)
=EUROCONVERT(A3,B3,C3,TRUE,3)
Result:
0.152
Converts 1 franc to the equivalent in euros by using a calculation and display precision of 2 decimal places (0.15)
=EUROCONVERT(A4,B4,C4,FALSE,3)
Result:
0.15
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(A5,B5,C5,TRUE,3)
Result:
0.29728616
§ 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.
✦ Tips
- 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.
- This function does not apply a number format.
- This function cannot be used in array formulas.
⚠ Common Errors
#VALUE!
Invalid parameters return #VALUE.
Fix: Enter a valid ISO code
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!