If and countif

[apgmin]

Please help me with this!!
=IF(AND(COUNTIF(AM2:AT2,">1")>0,I2>0),"MODULES REATTEMPTED","PASSED IN FIRST ATTEMPT")
the above is the formula I have used but it is not working
I want the formula to first check if I2 is zero or greater than zero
If it is zero or empty it should not display anything

then if it is not empty or more than zero, I want it to activate the formula (if AM2 till AT2 is greater than 1), I want it to return the message MODULES REATTEMPTED
(if AM2 till AT2 is EQUAL TO ZERO), I want it to return the message PASSED IN FIRST ATTEMPT

 

[Aladin Akyurek]

Try...

=IF(ISNUMBER(1/I2),"",IF(COUNTIFS(AM2:AT2,">1"),"MODULES REATTEMPTED","PASSED IN FIRST ATTEMPT"))

 

[apgmin]

It does not work as even if I2 is empty it still displays the results
However based on your reply I did the following changes and this works perferctly, thanks for your help
=IF(I2=0,"",IF(COUNTIFS(AM2:AT2,">1"),"MODULES REATTEMPTED","PASSED IN FIRST ATTEMPT"))

 

[Aladin Akyurek]

It does not work as even if I2 is empty it still displays the results
However based on your reply I did the following changes and this works perferctly, thanks for your help
=IF(I2=0,"",IF(COUNTIFS(AM2:AT2,">1"),"MODULES REATTEMPTED","PASSED IN FIRST ATTEMPT"))

I meant to post;

=IF(ISNUMBER(1/I2),IF(COUNTIFS(AM2:AT2,">1"),"MODULES REATTEMPTED","PASSED IN FIRST ATTEMPT"),"")