USE OF IF FORMULA??

[Kieran]

I'm looking for a formula to convert a list of figures in
a column to EUR. E.G. COL A shows the currency code, the
figures are in COL B. Therefore I want to multiply the
figures by an exchange rate depending on the currency
code in COL A.How can I do this.

Thanks

 

[Bernard Liengme]

In K1:L20 we have a table like this (I have made up the codes and numbers)
UK 2.45
USA 2.68
CND 3.56
etc

In A1 user enters USA and in B1 she enter 100
In C1 you have =VLOOKUP(A1,K1:L20,2,FALSE)*B1
The lookup finds 2.68 and the formula returns 100*2.68

The table can be on an otherwise unused sheet in the workbook.

best wishes
Bernard

 

[firefytr]

Tools -> Addins -> Euro Currency Tools.

This should get you started in the right direction