+ or - ?
 

=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

+ or - ?
 

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

+ or - ?
 

One way:

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

Tyro

"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

+ or - ?
 

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

+ 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

+ or - ?
 

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

"Pete_UK" wrote in message
...
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

+ or - ?
 

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

On Feb 6, 8:16*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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

"Pete_UK" wrote in message

...
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- Hide quoted text -

- Show quoted text -