This would be the formula for cell "D1"

=if(b1="EUR",A1*.74,"")

If the value in "B1" is "EUR", then "A1" times .74 will appear in "D1". If
"B1" is not "EUR", then nothing will appear in "D1".

"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