EUROCONVERT

EUROCONVERT(number, source, target [,precision] [,triangular])

Returns the number converted to euros.

numberThe number you want to convert.
sourceThe ISO country code for the source currency (see below).
targetThe ISO country code for the currency to convert to (see below).
precision(Optional) A logical value indicating how the result will be displayed:
False (or 0) = the currency specific rounding rules applied (default)
True (<> 0) = all significant digits are displayed
triangular(Optional) An integer value (>= 3) to specify the number of significant digits when converting from one euro member currency to another.

REMARKS
* This function is only available if you have the Euro Currency Tools add-in installed.
* This function does not appear in the Function Wizard or the Cell AutoComplete.
* This function uses the fixed conversion rates that were fixed by the European Union.
* The "number" can be a cell reference or named range.
* If "source" is not a recognised ISO code, then #VALUE! is returned.
* If "source" = "target" then the original value is returned.
* If "fprecision" = True, then all significant digits resulting from the calculation are displayed.
* If "precision" = False, then the result is displayed with the currency specific rounding rules applied.
* If "precision" is left blank, then False is used.
* If "triangular" is left blank, then the intermediate Euro value is not rounded.
* ATS - Austrian Schilling ( 1 euro = 13.7603, calc precision = 2, display precision = 2 )
* BEF - Belgian Franc ( 1 euro = 40.3399, calc precision = 0, display precision = 0 )
* DEM - Deutsche Mark ( 1 euro = 1.95583, calc precision = 2, display precision = 2 )
* ESP - Spanish Peseta (1 euro = 166.386, calc precision = 0, display precision = 0 )
* FIM - Finnish Markka ( 1 euro = 5.94573, calc precision = 2, display precision = 2 )
* FRF - French Franc ( 1 euro = 6.55957, calc precision = 2, display precision = 2 )
* GRD - Greek Drachma ( 1 euro = 340.750, calc precision = 2, display precision = 2 )
* IEP - Irish Pound ( 1 euro = 0.787564, calc precision = 2, display precision = 2 )
* ITL - Italian Lira ( 1 euro = 1936.27, calc precision = 0, display precision = 0 )
* LUF - Luxembourg Franc ( 1 euro = 40.3399, calc precision = 2, display precision = 2 )
* NLG - Netherlands Guilder ( 1 euro = 2.20371, calc precision = 2, display precision = 2 )
* PTE - Portuguese Escudo ( 1 euro = 200.482, calc precision = 0, display precision = 0 )
* EUR - Euro ( calc precision = 2, display precision = 2 )
* Any trailing zeros in the return value are removed. See Example 5.
* This function cannot be used in array formulas.
* This function does not apply a number format.
* This function is always displayed in lowercase.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=EUROCONVERT(1.2,"DEM","EUR") = 0.61
2=EUROCONVERT(1,"FRF","EUR",False,3) = 0.15
3=EUROCONVERT(1,"FRF","EUR",True,3) = 0.152
4=EUROCONVERT(1,"FRF","DEM",False,3) = 0.3
5=EUROCONVERT(1,"FRF","DEM",True,3) = 0.29728616
6=EUROCONVERT(100,"BEF","LUF") = 100
7=EUROCONVERT(100,"BEF","LUF",FALSE) = 100
8=EUROCONVERT(100,"DEM","ESP") = 8507
9=EUROCONVERT(100,"FRF","IEP") = 12.01
10=EUROCONVERT(100,"ITL","NLG") = 0.11
11=EUROCONVERT(100,"ATS","PTE") = 1457
12=EUROCONVERT(100,"FIM","EUR") = 16.82
13=EUROCONVERT(100,"FIM","FIM") = 100
14=EUROCONVERT(100,"ABC","EUR") = #VALUE!
15=EUROCONVERT(100,"FIM","ABC") = #VALUE!

1 - How many Euros is 1.2 Deutsche Mark. The result is given to 2 decimal places because Euros are displayed with a precision of 2 decimal places.
2 - How many Euros is 1 French Franc. The result is given to 2 decimal places because the calculating precision for the Euro is 2 decimal places.
3 - How many Euros is 1 French Franc. The result is given to 3 decimal places because the "full_precision" is True all significant figures are displayed.
4 - How many Deutsche Marks is 1 French Franc. The result is given to 2 decimal places because the calculating precision for the Deutsche mark is 2 decimal places.
5 - How many Deutsche Marks is 1 French Franc. The result is given to 8 decimal places because the "full_precision" is True all the significant figures are displayed.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top