Navigation:  Formula Reference > Spreadsheet Formula Functions >

EUROCONVERT

Previous pageReturn to chapter overviewNext page

 

This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).

Syntax

EUROCONVERT(currency,source,target,fullprecision,triangulation)

Arguments

This function has these arguments:

Argument

Description

currency

Number to convert

source

ISO currency code for the number to convert (see table below)

target

ISO currency code for the result of the conversion (see table below)

fullprecision

[Optional] Logical value representing whether to display the value in full precision or not; if omitted, the value is not displayed in full precision

triangulation

[Optional] Integer greater than or equal to 3 that specifies the number of significant digits to be used for the intermediate Euro value when converting between two Euro member currencies

If triangulation is omitted, the calculation does not round the intermediate Euro value. If it is included when converting from a Euro member currency to the Euro, the calculation finds the intermediate Euro value that could then be converted to a Euro member currency.

Remarks

This function does not convert all currencies; only those Euro member currencies listed in this table.

Country/Region

ISO Currency Code

Belgium

BEF

Luxembourg

LUF

Germany

DEM

Spain

ESP

France

FRF

Ireland

IEP

Italy

ITL

Netherlands

NLG

Austria

ATS

Portugal

PTE

Finland

FIM

Euro member state

EUR

ISO Currency Codes are from ISO 4217, the international standard describing three-letter codes to define the names of currencies. ISO is the nickname for the International Organization for Standardization.The first two letters of the code are the two-letter country codes (ISO 3166) and the third is usually the initial of the currency itself. So BEF is Belgium Franc.

Data Types

Accepts numeric and string data for most arguments; the fullprecision argument is a logical value. Returns numeric data.

Examples

EUROCONVERT(B5,"DEM","EUR")

EUROCONVERT(R5C2,"DEM","EUR", TRUE, 3)

 

See Also

ROUND