I need help with the following. In one column, say Column A, I have different figures appearing in three different currencies (USD, EUR and GBP), for example, A1 = USD 45, A2 = GBP 65, A3 = EUR 78, A4 = EUR 34, A5 = GBP 22, etc. I want to be able to create a formula in another column so that all values are converted to Euros. I thought it might be possible using the IF function that given the specific currency would multiply or divide by some given amount, but I don't know how to do it.
HELP! Thanks