Try this:

=ABS(+B1-A1)<=0.5

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"M.A.Tyler" <Great Lakes State wrote in message
...
=IF(A1=B1,TRUE,FALSE), easy enough, but how about A1 being within .5 of
B1?
In other words if B1=5, the statement would be true if A1=anywhere from
4.5
- 5.5.

is there a way to write this formula?

Thanks!

M.A.Tyler