XL2000: EUROCONVERT Rounds Number Up (231015)

CAUSE

This behavior occurs when you do both of the following:

You set the Full_Precision argument to FALSE or 0.

-and-
You set the Triangulation_Precision argument to 3.

For example, this problem occurs when you convert French francs to euros using the following formula:

=EUROCONVERT(100,"FRF","EUR",FALSE,3)

This formula returns 15.25.

However, if you set the Full_Precision argument to TRUE or 1 in the same formula, it will return 15.245.

WORKAROUND

If you want to round the result of the EUROCONVERT by setting the Full_Precision argument to FALSE, increase the value of the Triangulation_Precision argument. Using the example in the "Cause" section, setting the Triangulation_Precision to a value of 4 would cause the first formula to return 15.24 instead of 15.25.

MORE INFORMATION

The EUROCONVERT worksheet functions use the European Union (EU) members' conversion factors to express one euro in each of the euro member currencies. (See the help topic listed in the "References" section later in this article for a list of these euro member currencies.) Each EU rate has six significant digits. For example, one euro might be 6.55957 French francs or 1.95583 deutsche marks. When EUROCONVERT converts values to euros, it rounds the result to the nearest cent within two decimal places (each euro contains 100 cents). When converting to another currency, if the result is exactly half of the smallest unit, EUROCONVERT rounds up the result.

Discrepancies may result however, if you round the results. Using the Triangulation_Precision argument of the EUROCONVERT function helps to correct these rounding errors.

REFERENCES