+ or - ?

[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

 

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

 

[Tyro]

One way:

=AND(A1>=B1-.5,A1<=B1+.5)

Tyro

 

[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

 

[M.A.Tyler]

All good, thanks as always!

Try this:

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

or even:

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

Hope this helps.

Pete

 

[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

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

 

[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