how do i set formula to be equal to a value plus or minus 1?
=IF(ABS(A1-B1)<=1,"OK","Not OK")
"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.
|