Hi,
I am struggling to get this part of my formula to fire:
IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$25,"<3")>=3,F5<=2,Z5<>"",Z5>4),"F0.2",""))
Can anyone see what I've done wrong? Here's the full formula:
=IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$25,"<2")>=2,F5<=2,Z5<>"",Z5>3),"F0.2",IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$25,"<3")>=3,F5<=2,Z5<>"",Z5>4),"F0.2",""))))
Thanks
I am struggling to get this part of my formula to fire:
IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$25,"<3")>=3,F5<=2,Z5<>"",Z5>4),"F0.2",""))
Can anyone see what I've done wrong? Here's the full formula:
=IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$25,"<2")>=2,F5<=2,Z5<>"",Z5>3),"F0.2",IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$25,"<3")>=3,F5<=2,Z5<>"",Z5>4),"F0.2",""))))
Thanks