EUROCONVERT
Unsupported (not recognized)Category: Add-in and Automation · Last tested 2026-09-01
Real compatibility results for the EUROCONVERT function: executed in Excel for the web, Google Sheets and LibreOffice Calc, with desktop Excel behavior from Microsoft’s official documentation (we do not run desktop Excel — Excel for the web is a different application and is executed separately). Syntax and links to that documentation are below.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel (desktop) | Yes | No — documented only | n/a |
| Excel for the web | — | Yes (recalc, 2026-09-01) | Unsupported (not recognized) |
| Google Sheets | No | Yes (Drive import, 2026-08-31) | Unsupported (not recognized) |
| LibreOffice Calc | Yes | Yes (25.8.7.3, 2026-08-31) | Supported, behaves as documented |
LibreOffice version history
We executed the same test cases under each LibreOffice release to show exactly when EUROCONVERT’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 24.2.0.3 | Supported, behaves as documented | 2026-08-31 |
| 24.8.7.2 | Supported, behaves as documented | 2026-08-31 |
| 25.2.0.3 | Supported, behaves as documented | 2026-08-31 |
| 25.8.7.3 | Supported, behaves as documented | 2026-08-31 |
Why isn’t EUROCONVERT working in Google Sheets?
Google Sheets does not implement EUROCONVERT: we imported the formula into
Sheets on 2026-08-31 and every case came back #NAME?
(unrecognized function). Sheets is a rolling service with no version to pin, so this is a
statement about the service on that date, and Google’s own
function list does not document it either. Rewrite the formula with a documented
Sheets equivalent — see the
Excel ↔ Sheets equivalents table.
Discovered quirks
-
=EUROCONVERT(1.2,"DEM","EUR") on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.61.
Provenance
Microsoft publishes '=EUROCONVERT(A2,B2,C2)' over the data 1.20 / DEM / EUR with the result 0.61 and the note "by using a calculation and display precision of 2 decimal places". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1.20 / 1.95583 = 0.6135502574354622, and with full_precision omitted the documented default is FALSE, which applies the currency-specific rounding from the page's own table -- EUR display precision 2 -- giving 0.61.; MISMATCH vs expected: expected 0.61, got '#NAME?'
-
=EUROCONVERT(1,"FRF","EUR",TRUE,3) on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.152.
Provenance
Microsoft publishes '=EUROCONVERT(A3,B3,C3,TRUE,3)' with the result 0.152. Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, and the documented triangulation_precision of 3 rounds the intermediate euro value to 3 significant digits, giving 0.152; full_precision TRUE then displays all significant digits of that value rather than re-rounding to the EUR display precision.; MISMATCH vs expected: expected 0.152, got '#NAME?'
-
=EUROCONVERT(1,"FRF","EUR",FALSE,3) on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.15.
Provenance
Microsoft publishes '=EUROCONVERT(A4,B4,C4,FALSE,3)' with the result 0.15 and the note "by using a calculation and display precision of 2 decimal places". Derived: the same 0.152 intermediate as the previous case, then rounded to the EUR display precision of 2 from the page's rounding table, giving 0.15. This case and the previous one differ only in the full_precision flag, which is the whole point -- an engine that ignores that argument returns the same number for both.; MISMATCH vs expected: expected 0.15, got '#NAME?'
-
=EUROCONVERT(1,"FRF","DEM",TRUE,3) on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.29728616.
Provenance
Microsoft publishes '=EUROCONVERT(A5,B5,C5,TRUE,3)' with the result 0.29728616 and the note "by using an intermediate calculation precision of 3 and displaying all significant digits". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, rounded to the documented 3 significant digits of triangulation precision = 0.152, then multiplied by the DEM rate 1.95583 = 0.29728616 exactly. This is the case that proves the intermediate rounding really happens: without it the answer would be 0.1524490172374104 * 1.95583 = 0.2981650... , nowhere near the published figure.; MISMATCH vs expected: expected 0.29728616, got '#NAME?'
-
=EUROCONVERT(1,"XYZ","EUR") on
Excel for the web returned
#NAME?, but the documented/expected
result is #VALUE!.
Provenance
Excel documents fourteen accepted ISO codes (BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD, SIT, EUR) and the blanket remark "Invalid parameters return #VALUE." XYZ is not among them.; MISMATCH vs expected: expected '#VALUE!', got '#NAME?'
-
=EUROCONVERT(1.2,"DEM","EUR") on
Google Sheets returned
#NAME?, but the documented/expected
result is 0.61.
Provenance
Microsoft publishes '=EUROCONVERT(A2,B2,C2)' over the data 1.20 / DEM / EUR with the result 0.61 and the note "by using a calculation and display precision of 2 decimal places". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1.20 / 1.95583 = 0.6135502574354622, and with full_precision omitted the documented default is FALSE, which applies the currency-specific rounding from the page's own table -- EUR display precision 2 -- giving 0.61.; MISMATCH vs expected: expected 0.61, got '#NAME?'
-
=EUROCONVERT(1,"FRF","EUR",TRUE,3) on
Google Sheets returned
#NAME?, but the documented/expected
result is 0.152.
Provenance
Microsoft publishes '=EUROCONVERT(A3,B3,C3,TRUE,3)' with the result 0.152. Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, and the documented triangulation_precision of 3 rounds the intermediate euro value to 3 significant digits, giving 0.152; full_precision TRUE then displays all significant digits of that value rather than re-rounding to the EUR display precision.; MISMATCH vs expected: expected 0.152, got '#NAME?'
-
=EUROCONVERT(1,"FRF","EUR",FALSE,3) on
Google Sheets returned
#NAME?, but the documented/expected
result is 0.15.
Provenance
Microsoft publishes '=EUROCONVERT(A4,B4,C4,FALSE,3)' with the result 0.15 and the note "by using a calculation and display precision of 2 decimal places". Derived: the same 0.152 intermediate as the previous case, then rounded to the EUR display precision of 2 from the page's rounding table, giving 0.15. This case and the previous one differ only in the full_precision flag, which is the whole point -- an engine that ignores that argument returns the same number for both.; MISMATCH vs expected: expected 0.15, got '#NAME?'
-
=EUROCONVERT(1,"FRF","DEM",TRUE,3) on
Google Sheets returned
#NAME?, but the documented/expected
result is 0.29728616.
Provenance
Microsoft publishes '=EUROCONVERT(A5,B5,C5,TRUE,3)' with the result 0.29728616 and the note "by using an intermediate calculation precision of 3 and displaying all significant digits". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, rounded to the documented 3 significant digits of triangulation precision = 0.152, then multiplied by the DEM rate 1.95583 = 0.29728616 exactly. This is the case that proves the intermediate rounding really happens: without it the answer would be 0.1524490172374104 * 1.95583 = 0.2981650... , nowhere near the published figure.; MISMATCH vs expected: expected 0.29728616, got '#NAME?'
-
=EUROCONVERT(1,"XYZ","EUR") on
Google Sheets returned
#NAME?, but the documented/expected
result is #VALUE!.
Provenance
Excel documents fourteen accepted ISO codes (BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD, SIT, EUR) and the blanket remark "Invalid parameters return #VALUE." XYZ is not among them.; MISMATCH vs expected: expected '#VALUE!', got '#NAME?'
Executed test cases
Excel for the web (executed 2026-09-01 via OneDrive recalculation)
These values come from Excel for the web, not from desktop Excel. They are two different implementations of the calculation engine, and this run measured only the web one: the corpus was uploaded to OneDrive as .xlsx, recalculated by Excel for the web on open, and downloaded again for readback. Excel for the web is a rolling service with no pinnable version, so the run is identified by its date. Where a value here disagrees with the Expected column — which is Microsoft’s documentation of the desktop product — we cannot tell you whether the web engine diverges from the desktop one or the documentation is wrong about both, because we do not run desktop Excel.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =EUROCONVERT(1.2,"DEM","EUR") | Microsoft's documented worked example: 1.20 deutsche marks in euros, with full_precision omitted | #NAME? | 0.61ProvenanceMicrosoft publishes '=EUROCONVERT(A2,B2,C2)' over the data 1.20 / DEM / EUR with the result 0.61 and the note "by using a calculation and display precision of 2 decimal places". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1.20 / 1.95583 = 0.6135502574354622, and with full_precision omitted the documented default is FALSE, which applies the currency-specific rounding from the page's own table -- EUR display precision 2 -- giving 0.61. |
Mismatch |
| =EUROCONVERT(1,"FRF","EUR",TRUE,3) | Microsoft's documented worked example: 1 franc in euros at triangulation precision 3 | #NAME? | 0.152ProvenanceMicrosoft publishes '=EUROCONVERT(A3,B3,C3,TRUE,3)' with the result 0.152. Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, and the documented triangulation_precision of 3 rounds the intermediate euro value to 3 significant digits, giving 0.152; full_precision TRUE then displays all significant digits of that value rather than re-rounding to the EUR display precision. |
Mismatch |
| =EUROCONVERT(1,"FRF","EUR",FALSE,3) | Microsoft's documented worked example: the same conversion with full_precision FALSE | #NAME? | 0.15ProvenanceMicrosoft publishes '=EUROCONVERT(A4,B4,C4,FALSE,3)' with the result 0.15 and the note "by using a calculation and display precision of 2 decimal places". Derived: the same 0.152 intermediate as the previous case, then rounded to the EUR display precision of 2 from the page's rounding table, giving 0.15. This case and the previous one differ only in the full_precision flag, which is the whole point -- an engine that ignores that argument returns the same number for both. |
Mismatch |
| =EUROCONVERT(1,"FRF","DEM",TRUE,3) | Microsoft's documented worked example: franc to deutsche mark through the euro (triangulation) | #NAME? | 0.29728616ProvenanceMicrosoft publishes '=EUROCONVERT(A5,B5,C5,TRUE,3)' with the result 0.29728616 and the note "by using an intermediate calculation precision of 3 and displaying all significant digits". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, rounded to the documented 3 significant digits of triangulation precision = 0.152, then multiplied by the DEM rate 1.95583 = 0.29728616 exactly. This is the case that proves the intermediate rounding really happens: without it the answer would be 0.1524490172374104 * 1.95583 = 0.2981650... , nowhere near the published figure. |
Mismatch |
| =EUROCONVERT(1,"XYZ","EUR") | A source currency that is not one of the documented ISO codes | #NAME? | #VALUE!ProvenanceExcel documents fourteen accepted ISO codes (BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD, SIT, EUR) and the blanket remark "Invalid parameters return #VALUE." XYZ is not among them. |
Mismatch |
Google Sheets (executed 2026-08-31 via Drive import)
Google Sheets is a rolling service with no pinnable version, so this run is identified by its date. The corpus was imported to Drive as .xlsx, recalculated by Sheets, and exported back for readback.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =EUROCONVERT(1.2,"DEM","EUR") | Microsoft's documented worked example: 1.20 deutsche marks in euros, with full_precision omitted | #NAME? | 0.61ProvenanceMicrosoft publishes '=EUROCONVERT(A2,B2,C2)' over the data 1.20 / DEM / EUR with the result 0.61 and the note "by using a calculation and display precision of 2 decimal places". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1.20 / 1.95583 = 0.6135502574354622, and with full_precision omitted the documented default is FALSE, which applies the currency-specific rounding from the page's own table -- EUR display precision 2 -- giving 0.61. |
Mismatch |
| =EUROCONVERT(1,"FRF","EUR",TRUE,3) | Microsoft's documented worked example: 1 franc in euros at triangulation precision 3 | #NAME? | 0.152ProvenanceMicrosoft publishes '=EUROCONVERT(A3,B3,C3,TRUE,3)' with the result 0.152. Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, and the documented triangulation_precision of 3 rounds the intermediate euro value to 3 significant digits, giving 0.152; full_precision TRUE then displays all significant digits of that value rather than re-rounding to the EUR display precision. |
Mismatch |
| =EUROCONVERT(1,"FRF","EUR",FALSE,3) | Microsoft's documented worked example: the same conversion with full_precision FALSE | #NAME? | 0.15ProvenanceMicrosoft publishes '=EUROCONVERT(A4,B4,C4,FALSE,3)' with the result 0.15 and the note "by using a calculation and display precision of 2 decimal places". Derived: the same 0.152 intermediate as the previous case, then rounded to the EUR display precision of 2 from the page's rounding table, giving 0.15. This case and the previous one differ only in the full_precision flag, which is the whole point -- an engine that ignores that argument returns the same number for both. |
Mismatch |
| =EUROCONVERT(1,"FRF","DEM",TRUE,3) | Microsoft's documented worked example: franc to deutsche mark through the euro (triangulation) | #NAME? | 0.29728616ProvenanceMicrosoft publishes '=EUROCONVERT(A5,B5,C5,TRUE,3)' with the result 0.29728616 and the note "by using an intermediate calculation precision of 3 and displaying all significant digits". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, rounded to the documented 3 significant digits of triangulation precision = 0.152, then multiplied by the DEM rate 1.95583 = 0.29728616 exactly. This is the case that proves the intermediate rounding really happens: without it the answer would be 0.1524490172374104 * 1.95583 = 0.2981650... , nowhere near the published figure. |
Mismatch |
| =EUROCONVERT(1,"XYZ","EUR") | A source currency that is not one of the documented ISO codes | #NAME? | #VALUE!ProvenanceExcel documents fourteen accepted ISO codes (BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD, SIT, EUR) and the blanket remark "Invalid parameters return #VALUE." XYZ is not among them. |
Mismatch |
LibreOffice Calc 25.8.7.3 (tested 2026-08-31)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =EUROCONVERT(1.2,"DEM","EUR") | Microsoft's documented worked example: 1.20 deutsche marks in euros, with full_precision omitted | 0.61 | 0.61ProvenanceMicrosoft publishes '=EUROCONVERT(A2,B2,C2)' over the data 1.20 / DEM / EUR with the result 0.61 and the note "by using a calculation and display precision of 2 decimal places". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1.20 / 1.95583 = 0.6135502574354622, and with full_precision omitted the documented default is FALSE, which applies the currency-specific rounding from the page's own table -- EUR display precision 2 -- giving 0.61. |
Matched |
| =EUROCONVERT(1,"FRF","EUR",TRUE,3) | Microsoft's documented worked example: 1 franc in euros at triangulation precision 3 | 0.152 | 0.152ProvenanceMicrosoft publishes '=EUROCONVERT(A3,B3,C3,TRUE,3)' with the result 0.152. Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, and the documented triangulation_precision of 3 rounds the intermediate euro value to 3 significant digits, giving 0.152; full_precision TRUE then displays all significant digits of that value rather than re-rounding to the EUR display precision. |
Matched |
| =EUROCONVERT(1,"FRF","EUR",FALSE,3) | Microsoft's documented worked example: the same conversion with full_precision FALSE | 0.15 | 0.15ProvenanceMicrosoft publishes '=EUROCONVERT(A4,B4,C4,FALSE,3)' with the result 0.15 and the note "by using a calculation and display precision of 2 decimal places". Derived: the same 0.152 intermediate as the previous case, then rounded to the EUR display precision of 2 from the page's rounding table, giving 0.15. This case and the previous one differ only in the full_precision flag, which is the whole point -- an engine that ignores that argument returns the same number for both. |
Matched |
| =EUROCONVERT(1,"FRF","DEM",TRUE,3) | Microsoft's documented worked example: franc to deutsche mark through the euro (triangulation) | 0.29728616 | 0.29728616ProvenanceMicrosoft publishes '=EUROCONVERT(A5,B5,C5,TRUE,3)' with the result 0.29728616 and the note "by using an intermediate calculation precision of 3 and displaying all significant digits". Microsoft's page states the rates its examples assume: "1 euro = 6.55957 French francs and 1.95583 deutsche marks" (the irrevocable EU fixing rates), and every figure below was recomputed from them. Derived: 1 / 6.55957 = 0.1524490172374104, rounded to the documented 3 significant digits of triangulation precision = 0.152, then multiplied by the DEM rate 1.95583 = 0.29728616 exactly. This is the case that proves the intermediate rounding really happens: without it the answer would be 0.1524490172374104 * 1.95583 = 0.2981650... , nowhere near the published figure. |
Matched |
| =EUROCONVERT(1,"XYZ","EUR") | A source currency that is not one of the documented ISO codes | #VALUE! | #VALUE!ProvenanceExcel documents fourteen accepted ISO codes (BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD, SIT, EUR) and the blanket remark "Invalid parameters return #VALUE." XYZ is not among them. |
Matched |
Docs & syntax
- Excel (desktop): official documentation
- LibreOffice Calc: official documentation