Thread: IF statement value range required
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
meatshield meatshield is offline
external usenet poster
  
Posts: 39
Default IF statement value range required

wrote:
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"

Reply With QuoteReply With Quote