Dividing the value of a cell if another cell equals a set value
Hi John
One way, use a LOOKUP formula
=A2*LOOKUP(B2,{"CAD","EUR","GBP";0.498,0.74,1})
Copy down column C as far as required.
Change the rates to suit.
Regards
Roger Govier
mg_sv_r wrote:
Hi again,
Need help with another formula, I have the following table.
A B C D
1 19.00 GBP fred
2 27.00 EUR BOB
3 56.90 CAD Bill
I want a mathmatical function to multiply the value in column A by say 0.74
if the value in column B = "EUR" and enter the result in column D.
Thanks again for any help. It really is much appreciated.
John
|