I have a column with the numbers either 1, 2 or 3 relating to different currency - 1 stands for £, 2 stands for € and 3 stands for $. I then have 3 columns with the current exchange rate for each currency. I need a further column to have the correct formula to select the correct currency figure by reading what number is in the first column. So, if the first column has the number 2 in it, I need a formula that will give me the figure I have for the Euro exchange rate - but if I change the figure from 2 to 3, it needs to then automatically give me the figure for the $ currency - and the same if I change the figure to 1 it needs to give me the sterling currency figure. Help!!!!!!

You didn't say what you wanted to do with the exchange rate, so this formula will simply returnit.Assuming your 1, 2, 3 are in Column A and your exchange rates are in Column B:D, try this:

=IF(A1=1,B1,IF(A1=2,C1,D1))

Note: This formula will return D1 if A1 is anything except 1 or 2.

If it were me, I'd use a Data Validation Drop Down in A1 to ensure that only a 1, 2 or 3 were entered.

You could also use something like this to ensure a 1,2 or 3 is entered:

=IF(AND(A1<>1,A1<>2,A1<>3),"Enter a 1, 2 or 3 in A1",IF(A1=1,B1,IF(A1=2,C1,D1)))

If you need to actually do something with the exchange rate, like multiply a value from another cell with it, something like this should work.

=IF(A1=1,B1*F1,IF(A1=2,C1*F1,D1*F1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History