| | | This function is only available if you have the Euro Currency Tools add-in installed. |
| | | 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 "full-precision" = True, then all significant digits resulting from the calculation are displayed. |
| | | If "full-precision" = False, then the result is displayed with the currency specific rounding rules applied. |
| | | If "full-precision" is left blank, then False is used. |
| | | If "triangular_precision" 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 lower case. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | Example 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. |
| | | | 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! |
| |
