multiply on a text answer

Hi

I would like to be able to multiply a1 & b1 on the answer in c1 = yes = complete the sum no = returns a zero

a1 b1 c1 d1
5 5 yes 25

a1 b1 c1 d1
5 5 no 0

thanks Mike

Hi Mike

formula should be =IF(C1="YES";A1*B2;0)

Gregory.

doesn't seem to work

Try
=IF(C1="YES",A1*B1,0)

yes thanks

you always need to check if your Excel is set with , or ; and replace it in your formulas, depends on your regional settings