Difference between revisions of "Documentation/How Tos/Calc: CONVERT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 45: | Line 45: | ||
: converts <tt>'''100'''</tt> Euros into German Marks. | : converts <tt>'''100'''</tt> Euros into German Marks. | ||
− | + | {{Documentation/SeeAlso| | |
− | + | * [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]]''' | |
− | + | * [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | |
− | + | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]]''' | |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 13:36, 25 February 2009
CONVERT
Converts legacy European national currencies to and from Euros.
Syntax:
CONVERT(value; currency1; currency2)
- value is the amount of the currency to be converted.
- currency1 and currency2 are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"), as shown in the table below. The rates (shown per Euro) were set by the European Commission. The legacy currencies were replaced by the Euro in 2002.
"EUR" | "ATS" | 13.7603 | Austrian Schilling |
"EUR" | "BEF" | 40.3399 | Belgian Franc |
"EUR" | "DEM" | 1.95583 | German Mark |
"EUR" | "ESP" | 166.386 | Spanish Peseta |
"EUR" | "FIM" | 5.94573 | Finnish Markka |
"EUR" | "FRF" | 6.55957 | French Franc |
"EUR" | "IEP" | 0.787564 | Irish Pound |
"EUR" | "ITL" | 1936.27 | Italian Lira |
"EUR" | "LUF" | 40.3399 | Luxembourg Franc |
"EUR" | "NLG" | 2.20371 | Dutch Guilder |
"EUR" | "PTE" | 200.482 | Portuguese Escudo |
"EUR" | "GRD" | 340.750 | Greek Drachma |
- Either currency1 or currency2 must be specified as Euros.
Example:
CONVERT(100;"ATS";"EUR")
- converts 100 Austrian Schillings into Euros.
CONVERT(100;"EUR";"DEM")
- converts 100 Euros into German Marks.