Manuals/calci/EUROCONVERT

EUROCONVERT (Amount,FromCurrency,ToCurrency,Precision,TriangulationPrecision)

• where $Amount$ is the currency value to convert
• $FromCurrency$ is a three letter string or code of source currency
• $ToCurrency$ is a three letter string or code of target currency
• $Precision$(Full precision) is a logical value TRUE or FALSE that specifies how to display the result
• $TriangulationPrecision$ 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 member currency to another by using the euro as an intermediary (triangulation).

Description

EUROCONVERT (Amount,FromCurrency,ToCurrency,Precision,TriangulationPrecision)

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)TO convert currency of 'Austria' to currency of 'France', following function can be used -

EUROCONVERT(1,"ATS","FRF",FALSE,3) returns 0.45

• The $FromCurrency$ and $ToCurrency$ 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

• The $FromCurrency$ and $ToCurrency$ currency codes should be entered in double quotes (e.g. "EUR").
• $Precision$ can be a logical value TRUE(or 1) or FALSE(or 0). If argument is TRUE(or 1), Calci displays all significant digits.
• If $Precision$ is omitted, Calci assumes it as FALSE(or 0) and uses default precision.
• $TriangulationPrecision$ is the triangular precision integer value >=3 that specifies the number of significant digits to be used for converting intermediate euro value, while converting between two euro member currencies.
• If $FromCurrency$ and $ToCurrency$ codes are same, Calci returns the original value.
• If any argument is invalid, Calci displays a #NULL error message.

Examples

	ColumnA	ColumnB	ColumnC	ColumnD
Row1	2.2	DEM	EUR	FALSE
Row2	1	ATS	EUR
Row3	1	EUR	ESP	TRUE
Row4	1	FRF	BEF	TRUE
Row5

=EUROCONVERT(A1,B1,C1,D1) : Converts 2.2 duetse mark into euros. Returns 1.12.
=EUROCONVERT(A2,B2,C2) : Converts 1 schilling into euros. Returns 0.07.
=EUROCONVERT(A3,B3,C3,D3) : Converts 1 euros into peseta. Returns 166.386.
=EUROCONVERT(A4,B4,C4,D4,3) : Converts 1 franc into Belgium franc with intermediate precision of 3. Returns 6.1316648.

Related Videos

CURRENCY EXCHANGE

See Also

• DOLLARDE
• DOLLARFR

Reference

• Euro

• List of Main Z Functions

• Z3 home