I have a list of prices in $ in column A and need them into euro’s in column B.
In the help I found the function CONVERT with an example:
=CONVERT(100;“ATS”;“EUR”) returns the Euro value of 100 Austrian Schillings.
=CONVERT(100;“EUR”;“DEM”) converts 100 Euros into German Marks.
and thought putting in column B : =CONVERT(A11,“USD”,“EUR”) would do the trick, but it returns #N/A.
Help ? Thy