Registered User Joined: 3/10/2012 Posts: 465
|
Bruce how to write pcf in "Not " function for below formula when neither is true or false
C > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C > (MAXH52.26 + MINL52.26) / 2 and avgc20 > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 and avgc20 > (MAXH52.26 + MINL52.26) / 2
C < (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C < (MAXH52.26 + MINL52.26) / 2 and avgc20 < (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 and avgc20 < (MAXH52.26 + MINL52.26) / 2
thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I don't understand the question. You have two formulas. Do you want the formula to return true when neither formula is true?
NOT(C > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C > (MAXH52.26 + MINL52.26) / 2 and avgc20 > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 and avgc20 > (MAXH52.26 + MINL52.26) / 2) AND NOT(C < (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C < (MAXH52.26 + MINL52.26) / 2 and avgc20 < (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 and avgc20 < (MAXH52.26 + MINL52.26) / 2)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/10/2012 Posts: 465
|
yes thats what i was intending to ask
thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|