Darn typos!

The formula should be:
C1: =IF((MAX(A1,B1)-MIN(A1,B1))<1,"OK","Exceeds limit")

Note: that works even if one or both of the numbers are negative.

(Sorry about the typo)
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Maybe something like this:

For values in A1 and B1

C1: =IF((MAX(A1,B1)-MIN(A1,A1))<=1,"OK","Exceeds limit")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Aaron" wrote:

i want an if then statement. i have it now so that something happens if x =
y. well, i want the same thing to happen if x = y plus or minus 1. i found
that x is often within .1 or 1 of y and that is close enough for me to want
the something to happen. thanks.