IF function w/ 'and' condition

M

MikeyS

Joined
Aug 14, 2012
Messages
4
Reaction score
0
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
 
Last edited:
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")
 
Back
Top