+ or - ?

M

M.A.Tyler

=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
 
R

Ron Coderre

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)
 
P

Pete_UK

Try this:

=IF(ABS(B1)-ABS(A1)<=0.5,TRUE,FALSE)

or even:

=(ABS(B1)-ABS(A1))<=0.5

Hope this helps.

Pete
 
D

David Biddulph

No, Pete, because that would return true for any value of A1 <=-4.5 or
=+4.5 rather than for values between +4.5 and +5.5
Click to expand...

You ned to change (ABS(B1)-ABS(A1)) to (ABS(B1-A1))
--
David Biddulph

Try this:

=IF(ABS(B1)-ABS(A1)<=0.5,TRUE,FALSE)

or even:

=(ABS(B1)-ABS(A1))<=0.5

Hope this helps.

Pete
 
P

Pete_UK

Right, David, thanks.

I thought I was checking for the difference of the magnitures, but
have now re-read the OP's request - that always helps !! <bg>

Pete
 
Top