Help with a formula if yes calculate and if no 0
 

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!

Help with a formula if yes calculate and if no 0
 

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

"Saphire69" wrote:

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!

Help with a formula if yes calculate and if no 0
 

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

On Mar 27, 2:45*pm, Saphire69 wrote:
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!