Manuals/calci/EUROCONVERT
Syntax
Examples-1
Description
It converts a number to euros, converts a number from euros to a euro member currency.
EUROCONVERT(N,src,target,FP,TP)
where num is the currency value that is to be convert,src is a reference to a cell containing the string, corresponding to the ISO code for the source currency.
Currency codes that are available in the EUROCONVERT function:
|
|
|
|
|
Belgium |
franc |
BEF |
|
Luxembourg |
franc |
LUF |
|
Germany |
deutsche mark |
DEM |
|
Spain |
peseta |
ESP |
|
France |
franc |
FRF |
|
Ireland |
pound |
IEP |
|
Italy |
lira |
ITL |
|
Netherlands |
guilder |
NLG |
|
Austria |
schilling |
ATS |
|
Portugal |
escudo |
PTE |
|
Finland |
markka |
FIM |
|
Greece |
drachma |
GRD |
|
Slovenia |
tolar |
SIT |
|
Euro member states |
euro |
EUR |
target is a three-letter string, or cell reference, corresponding to the ISO code of the currency for which the number is converted.
FP is a logical value (1 or 0) which specifies how to display the result and
TP is 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.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2.2 | DEM | EUR | 1.12 |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Let's see an example in Column1Row1,Column2Row1,Column3Row3
Let B2 = 2.2
C2= DEM
D2=EUR
ie.=EUROCONVERT(C1R1,C2R1,C3R1) is 1.12
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | NLG | EUR | 0.45 |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Let B2 = 1
C2= NLG
D2=EUR
ie.=EUROCONVERT(C1R1,C2R1,C3R1) is 0.45