Help with a formula if yes calculate and if no 0

[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!

 

[daniel]

=if(G2="YES",B2*.03,0)

 

[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