Help with a formula if yes calculate and if no 0

S

Saphire69

I am trying to make a formula that if G2 says yes, multiply B2 x .03
and if G2 says no, leave as 0. I guess I could add in a check box for
yes but i dont know how to link it to the cell. My formula wont work
and keeps coming back invalid.
I would appreciate any help with this.
Thanks so much!
 
P

Pete_UK

Try this:

=IF(G2="yes",B2*0.03,IF(G2="no",0,""))

This returns a blank if G2 is neither yes nor no.

Hope this helps.

Pete
 
Top