USE OF IF FORMULA??

  • Thread starter Thread starter Kieran
  • Start date Start date
K

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
 
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
 
Tools -> Addins -> Euro Currency Tools.

This should get you started in the right direction
 
Back
Top