=EUROCONVERT(number,source,target,full_precision,triangulation_precision)
=EUROCONVERT(A2,B2,C2)
The EUROCONVERT function allows for easy currency conversions. In this example, the formula can be used to convert 1.2 Deutsche Marks to Euros with a calculation and display precision of 2 decimal places.
=EUROCONVERT(A3,B3,C3,TRUE,3)
The EUROCONVERT function is also able to convert between several different currencies. In this example, the formula can be used to convert 1 French Franc to Euros with a calculation and display precision of 3 decimal places.
=EUROCONVERT(A4,B4,C4,FALSE,3)
The EUROCONVERT function can be used to convert between currencies in both directions. This example can be used to convert 1 French Franc to its equivalent in Deutsche Marks with a calculation and display precision of 3 decimal places.
=EUROCONVERT(A5,B5,C5,TRUE,3)
The EUROCONVERT function can also be used to display all significant digits in the result. In this example, the formula can be used to convert 1 French Franc to its equivalent in Deutsche Marks with an intermediate calculation precision of 3 and displaying all significant digits.
The EUROCONVERT function converts a number from one Euro member currency to another using the Euro as an intermediary. It requires five arguments: number, source, target, full_precision, and triangulation_precision.