IF Statement with two variables

[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")

 

[Glenn]

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")

 

[Bob Umlas]

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

 

[Mike H]

Hi

& is the concatenate symbol yo want AND

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

Mike

 

[Sean Timmons]

Or if you want to be fancy:

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

 

[Mike H]

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]

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

 

[Sean Timmons]

Please see myriad responses to your post from a couple minutes ago. Should
cover you.

 

[RoadKill]

Works great, thanks Sean.

Or if you want to be fancy:

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