IF statement value range required

[michael.j.cripps]

I'm attempting to create an IF statement that returns a value of
satisfactory if the tolerance result is off by less then 1%. My
problem is that the possibility exists for both positive and negative
numbers. Thus, a tolerance result of -5% still comes back as
satisfactory because it is less then 1. I need to define a range and I
do not know how. At present, my formula looks like this. Any advice
would be appreciated.

=IF(I29<=1,"SAT",IF(I29<=-1,"SAT",IF(I29="","","UNSAT")))

 

[meatshield]

I'm attempting to create an IF statement that returns a value of
satisfactory if the tolerance result is off by less then 1%. My
problem is that the possibility exists for both positive and negative
numbers. Thus, a tolerance result of -5% still comes back as
satisfactory because it is less then 1. I need to define a range and I
do not know how. At present, my formula looks like this. Any advice
would be appreciated.

=IF(I29<=1,"SAT",IF(I29<=-1,"SAT",IF(I29="","","UNSAT")))

You could use the ABS function to return the absolute value, thus
negating the need for individual positive/negative checks.
=IF(I29="","",IF(ABS(I29)<=1,"SAT","UNSAT"))
IF I29 is "", it returns ""
If the number is between -1 and 1, it returns SAT, if it is outside
that range, it returns "UNSAT"

 

[michael.j.cripps]

Sir, you are a godsend. Thank you much.
It has been literally years since I've done anything like this and I
must say I am enjoying wading through all of these formulas, tools and
all around options.

What a great resource these groups are!