IF function w/ 'and' condition

[MikeyS]

Excel - IF function w/ 'and' condition

Hello, I am trying to set up an IF statement that has two conditions. I read a prior thread that was helpful, but I cannot get mine to work.

My two logical tests are as follows for variables let's call x and t:
if x>(y-.5)
and if (r-2)<t<(r+2.5)
then output "A" else "B"

does that make sense? here is my formula...

=IF(AND((O37>(Q37-.5)),((G37-2)<M37<(G37+2.5))),"A","B")

thank you for any suggestions you may have

 

[MikeyS]

Figured it out! Turns out that my greater than less than section needs to be two different conditions...

=IF(AND((O22>P22),((G22-2)<M22),((G22+2.5)>M22)),"A","B")

 

[alow]

Glad you got it working! Thanks for posting back with the solution!