IF Statement with two variables
Fancy is fine if having "T" in H12 and "ier 1Yes" in J12 or any other of the
multiple other combinations is OK. I prefer evaluating the 2 conditions set
out by the OP
"Sean Timmons" wrote:
Or if you want to be fancy:
=IF(H12&J12="Tier 1Yes",150*B12,"None")
"Glenn" wrote:
RoadKill wrote:
I've gone brain dead on this.
Here is my formula, what am I doing wrong?
Thanks
=IF(H12="Tier 1" & J12="Yes",(150*B12),"None")
=IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None")
|