IF Statement with two variables

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

RoadKill

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")
 
RoadKill said:
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")
Click to expand...



=IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None")
 
Hi

& is the concatenate symbol yo want AND

=IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None")

Mike
 
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
 
Well, sure, though the likelihood of that error would be relatively low, it
also would allow for such things as matching full names where middle may be
in one of two cells. Guess it all depends on the goal of the formula...
 
Please see myriad responses to your post from a couple minutes ago. Should
cover you.
 
Back
Top