+ or - ?
All good, thanks as always!
"Pete_UK" wrote:
Try this:
=IF(ABS(B1)-ABS(A1)<=0.5,TRUE,FALSE)
or even:
=(ABS(B1)-ABS(A1))<=0.5
Hope this helps.
Pete
On Feb 6, 1:36 am, M.A.Tyler <Great Lakes State wrote:
=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
|