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