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")
 
=IF(AND(H12="Tier 1",J12="Yes"),150*B12,"None")
Bob Umlas
Excel MVP
 
Hi

& is the concatenate symbol yo want AND

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

Mike
 
Or if you want to be fancy:

=IF(H12&J12="Tier 1Yes",150*B12,"None")
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help with SUM formula dependent on results of other cells 2
If cell value is between XX and XL, display B 4
If and value between two numbers 6
MAX/MIN in range potantially including text 1
IF with multiple formula/variable 5
7+ Nested if Statement using indirect function 6
IF Formula Porblems 1
Count if on Single Criteria with multiply conditions 1

Back
Top