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