View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] michael.j.cripps@exxonmobil.com is offline
external usenet poster
 
Posts: 2
Default IF statement value range required

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