Amend IF False Statement.

[dgavin]

I am currently using this formula

=IF(T5>0,"CLEAR",IF(AND(COUNTIF(Sheet2!$E$2:$E$5000,"F")+COUNTBLANK(Sheet2!$E$2:$E$5000)=4999,$I$2>=40,F5>0,Dutch!$D$62<100,$L$2=0,$S$1>=0,$S$1<=120,$U$1>3,$F$2<>"Suspended"),"GO",""))

If all critiera are met then the formula will return "GO", otherwise it returns blank.

Instead of blank I want to return "STOP" but only if F5<=1.5,L2>0 and S1<0

Many Thanks

 

[Comfy]

=IF(T5>0,"CLEAR",IF(AND(COUNTIF(Sheet2!$E$2:$E$5000,"F")+COUNTBLANK(Sheet2!$E$2:$E$5000)=4999,$I$2>=40,F5>0,Dutch!$D$62<100,$L$2=0,$S$1>=0,$S$1<=120,$U$1>3,$F$2<>"Suspended"),"GO",IF(AND(F5<=1.5,L2>0,S1<0),"STOP","")))

Possibly.

 

[Ruddles]

Instead of blank I want to return "STOP" but only if F5<=1.5,L2>0 and S1<0

To return "STOP" instead of blank if F5<=1.5,L2>0 and S1<0, try replacing "" with:-

[COLOR=red]IF(AND(F5<=1.5,L2>0,S1<0),"STOP",[/COLOR][B][COLOR=blue]""[/COLOR][/B][COLOR=red])[/COLOR]