AND & OR Together?

[honkin]

hi

I am trying to get a particular result, but I have obviously got the syntax slightly wrong in my formula and I wonder if someone might look at it and indicate where I went wrong.

Here is the formula:-

=IF(AND(Q2="L",P2<=2.2,OR(Q2="P",P2<=2.2)),95,IF(AND(Q2="W",P2<=2.2),-100*P2+100,0))

In a nutshell I want to see if cell Q2 has either "P" or "L" in it and P2 <=2.20 then the result is 95. If Q2 has "W" in it and P2 is <=2.20, then this calculation is performed -100*P2+100

I get the correct result if "L" or "W" are in Q2, but if it is a "P", the result is always showing up as 0, even if P2 is <=2.20.

Any idea what needs correcting to make the formula achieve the desired result?

Thanks in advance

 

[DanteAmor]

Try this

=IF(AND(OR(Q2={"L","P"}),P2<=2.2),95,IF(AND(Q2="W",P2<=2.2),-100*P2+100,0))

Or this


=IF(P2<=2.2,IF(OR(Q2={"L","P"}),95,IF(Q2="W",-100*P2+100,0)),0)

 

[honkin]

Try this

=IF(AND(OR(Q2={"L","P"}),P2<=2.2),95,IF(AND(Q2="W",P2<=2.2),-100*P2+100,0))

Or this


=IF(P2<=2.2,IF(OR(Q2={"L","P"}),95,IF(Q2="W",-100*P2+100,0)),0)

Thanks so much DanteAmor. They both seem to give the right result, so I can opt for either.

Thanks again

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.