EXCEL EUROCONVERT FUNCTION

Converts a number to euros, a number from euros to a euro member currency, or a number from one euro member currency to another using the euro as an intermediate (triangulation). The currencies available for conversion are those of European Union (EU) members who have embraced the euro. The function makes advantage of preset conversion rates set by the EU.

Syntax :

=EUROCONVERT(number,source,target,full_precision,triangulation_precision)

Parameters :

  • The EUROCONVERT function syntax includes the following arguments:

Number :-

  • This is required. The currency value to be converted, or a pointer to a cell containing the value.

Source: –

  • Required. A three-letter string, or a reference to a cell holding the string, equivalent to the ISO code for the source currency.

Ttarget:

  • A three-letter string, or cell reference, referring to the ISO code of the currency to which the number should be converted. The ISO codes may be found in the preceding Source table.

Complete precision: 

  • A logical value (TRUE or FALSE) or an expression that evaluates to TRUE or FALSE that indicates how the result should be displayed.
    Precision in

triangulation:

  • When converting between two euro member currencies, an integer equal to or higher than 3 indicates the number of significant digits to be utilised for the intermediary euro value. If this option is omitted, Excel does not round the intermediate euro value.

Step By Step Guide of EUROCONVERT Function

Example :

Copy the data in the table below and paste it into cell A1 of a new Excel spreadsheet. To see the results of formulae, select them, press F2, and then Enter. You can alter the column widths to see all of the data if necessary.

  • Any trailing zeros in the return value are truncated by Excel.
  • If the source ISO code and the destination ISO code are the same, Excel returns the number’s original value.
  • Invalid arguments produce the error #VALUE.
    This function does not use a numerical format.
  • This function is incompatible with array formulas.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now