Difference between revisions of "Manuals/calci/EUROCONVERT"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | =EUROCONVERT(num, src, target, FP, TP)= | |
| − | + | *where <math>num</math>is the currency value to convert | |
| + | *<math>src</math>a three letter string or code of source currency | ||
| + | *<math>target</math>a three letter string or code of target currency | ||
| + | *<math>FP</math>(Full precision) is a logical value TRUE or FALSE that specifies how to display the result | ||
| + | *<math>TP</math>(Triangular precision) is an integer for rounding the intermediate euro value | ||
| − | + | EUROCONVERT() | |
| − | + | *converts a number to euros | |
| − | + | *converts a number from euros to a euro member currency | |
| + | *converts a number from one euro currency to another with triangular precision | ||
| − | + | == Description == | |
| + | EUROCONVERT(num, src, target, FP, TP) | ||
| − | + | For Example, | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | 1)TO convert currency of 'France' to 'Euros', following function can be used - | |
| − | + | EUROCONVERT(5,"FRF","EUR",TRUE) ''returns 0.7622450861870519'' | |
| − | |||
| − | |||
| − | + | 2)TO convert currency of 'Austria' to 'Euros', following function can be used - | |
| − | + | EUROCONVERT(1,"ATS","EUR") ''returns 0.07'' | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | 3)2)TO convert currency of 'Austria' to currency of 'France', following function can be used - | |
| − | + | EUROCONVERT(1,"ATS","FRF",FALSE,2) ''returns 0.45'' | |
| − | |||
| − | + | *The <math>src</math> and <math>target</math> currency codes for 13 member countries of European Union can be used from the following code table - | |
| − | + | ||
| − | + | {| class="wikitable" | |
| − | + | |- | |
| − | | | + | !Country !!Basic Unit of Currency!!!ISO Code |
| − | + | |- | |
| − | | | + | | Austria || schilling || ATS |
| − | + | |- | |
| − | | | + | | Belgium || franc || BEF |
| − | | | + | |- |
| − | + | | Finland || markka || FIM | |
| − | | | + | |- |
| − | + | | France || franc || FRF | |
| − | | | + | |- |
| − | + | | Germany || deutsche mark || DEM | |
| − | |- | + | |- |
| − | | | + | | Greece || drachma || GRD |
| − | + | |- | |
| − | | | + | | Ireland || pound || IEP |
| − | + | |- | |
| − | | | + | | Italy || lira || ITL |
| − | + | |- | |
| − | |- | + | | Luxembourg || franc || LUF |
| − | | | + | |- |
| − | + | | Netherlands || guilder || NLG | |
| − | | | + | |- |
| − | + | | Portugal || escudo || PTE | |
| − | | | + | |- |
| − | + | | Slovenia || tolar || SIT | |
| − | |- | + | |- |
| − | | | + | | Spain || peseta || ESP |
| − | + | |- | |
| − | | | + | | Euro member states || euro ||EUR |
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | | | ||
| − | |||
|} | |} | ||
| − | < | + | *<math>FP</math> can be a logical value TRUE(or 1) or FALSE(or 0). If argument is TRUE(or 1), Calci displays all significant digits. |
| + | *If <math>FP</math> is omitted, Calci assumes it as FALSE(or 0) and uses default precision. | ||
| + | *<math>TP</math> is the triangular precision integer value >equal;3 that specifies the number of significant digits to be used for converting intermediate euro value, while converting between two euro member currencies. | ||
| + | *If <math>src</math> and <math>target</math> codes are same, Calci returns the original value. | ||
| + | *If any argument is invalid, Calci displays a #NULL error message. | ||
| − | + | == Examples == | |
| − | < | + | <div id="4SpaceContent" class="zcontent" align="left"> |
| − | + | {| id="TABLE2" class="SpreadSheet blue" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | {| id=" | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | | | + | | ColumnA |
| − | | | + | | ColumnB |
| − | | | + | | ColumnC |
| − | | | + | | ColumnD |
|- class="odd" | |- class="odd" | ||
| class=" " | Row1 | | class=" " | Row1 | ||
| class="sshl_f " | 2.2 | | class="sshl_f " | 2.2 | ||
| class=" " | DEM | | class=" " | DEM | ||
| − | | class=" | + | | class=" " | EUR |
| − | | class=" | + | | class=" " | FALSE |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| class=" " | Row2 | | class=" " | Row2 | ||
| − | | class=" | + | | class="sshl_f" | |
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class=" " | Row3 | |
| − | | class=" | + | | class="sshl_f" | |
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| − | | Row4 | + | | class=" " | Row4 |
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| Line 254: | Line 110: | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| − | + | | class=" " | | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | == See Also == | |
| + | *[[Manuals/calci/DOLLARDE | DOLLARDE]] | ||
| + | *[[Manuals/calci/DOLLARFR | DOLLARFR]] | ||
| − | + | == Reference == | |
| − | + | *[http://en.wikipedia.org/wiki/Euro Euro] | |
Revision as of 17:59, 20 December 2013
EUROCONVERT(num, src, target, FP, TP)
- where is the currency value to convert
- a three letter string or code of source currency
- a three letter string or code of target currency
- (Full precision) is a logical value TRUE or FALSE that specifies how to display the result
- (Triangular precision) is an integer for rounding the intermediate euro value
is the currency value to convert
a three letter string or code of source currency
a three letter string or code of target currency
(Full precision) is a logical value TRUE or FALSE that specifies how to display the result
(Triangular precision) is an integer for rounding the intermediate euro valueEUROCONVERT()
- converts a number to euros
- converts a number from euros to a euro member currency
- converts a number from one euro currency to another with triangular precision
Description
EUROCONVERT(num, src, target, FP, TP)
For Example,
1)TO convert currency of 'France' to 'Euros', following function can be used -
EUROCONVERT(5,"FRF","EUR",TRUE) returns 0.7622450861870519
2)TO convert currency of 'Austria' to 'Euros', following function can be used -
EUROCONVERT(1,"ATS","EUR") returns 0.07
3)2)TO convert currency of 'Austria' to currency of 'France', following function can be used -
EUROCONVERT(1,"ATS","FRF",FALSE,2) returns 0.45
- The and currency codes for 13 member countries of European Union can be used from the following code table -
| Country | Basic Unit of Currency | !ISO Code |
|---|---|---|
| Austria | schilling | ATS |
| Belgium | franc | BEF |
| Finland | markka | FIM |
| France | franc | FRF |
| Germany | deutsche mark | DEM |
| Greece | drachma | GRD |
| Ireland | pound | IEP |
| Italy | lira | ITL |
| Luxembourg | franc | LUF |
| Netherlands | guilder | NLG |
| Portugal | escudo | PTE |
| Slovenia | tolar | SIT |
| Spain | peseta | ESP |
| Euro member states | euro | EUR |
- can be a logical value TRUE(or 1) or FALSE(or 0). If argument is TRUE(or 1), Calci displays all significant digits.
- If is omitted, Calci assumes it as FALSE(or 0) and uses default precision.
- is the triangular precision integer value >equal;3 that specifies the number of significant digits to be used for converting intermediate euro value, while converting between two euro member currencies.
- If and codes are same, Calci returns the original value.
- If any argument is invalid, Calci displays a #NULL error message.