If you want to test if A1 is EXACTLY A2 +/- 1.5 then try this:
=IF(OR(A1+1.5=B1,A1-1.5=B1),"YES","NO")

If you want to test is A1 is BETWEEN A2 +/- 1.5, then this may be what
you want:
=IF(AND(A1=B1-1.5,A1<=B1+1.5),"YES","NO")

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=488199