EUROCONVERT function
Convert historical euro-transition amounts with fixed rates and explicit rounding
Uses the fourteen currency codes documented by Microsoft: EUR, BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD and SIT. These are fixed historical conversion rates, not live FX quotations. Optional full precision defaults to FALSE; optional euro-intermediate precision is at least three. The scalar browser adapter follows the documented calculation precision, including zero decimals for PTE and GRD, and does not apply number formatting. Microsoft documentation labels intermediate precision as significant digits, while its worked examples round decimal places; the supplied examples follow those worked examples. Native Excel may require the Euro Currency Tools add-in. Modern additions to the euro area are not inferred to be supported currency codes. Native Excel and Sheets recalculation remain pending.
Syntax
EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| Number | Yes | Required. The currency value you want to convert, or a reference to a cell containing the value.100 |
| Source | Yes | 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:"DEM" |
| Target | Yes | 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."EUR" |
| Full_precision | No | Optional. TRUE retains target calculation digits; FALSE or omitted applies the documented target calculation precision.false |
| Triangulation_precision | No | Optional integer of at least three. Rounds the intermediate euro amount when the source is a national currency; omitted leaves that amount unrounded. The worked examples use decimal-place rounding.3 |
Try EUROCONVERT
Read a historical mark amount in euros
=EUROCONVERT(A2,B2,C2,D2)39.1166 historical German marks divided by the fixed 1.95583 marks per euro equals 20 euros. This uses an irrevocable historical conversion rate, not a current exchange-rate service. Native Excel may require its Euro Currency Tools add-in.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
EUROCONVERT · top-level call
=EUROCONVERT(A2,B2,C2,D2)1 / 4 · Number
Required. The currency value you want to convert, or a reference to a cell containing the value.
EUROCONVERT reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Reference and compatibility
Univer 1.0.4 / Apache-2.0; original compatibility notes and ECB rate facts. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.