Billing Statement

2.In sheet Nested if statement, enter a nested if statement if cell E4, satisfying the following conditions:
a.IF the number of students having scored 8 or higher is greater than 9, display “class highly productive” in cell E4
b.If the number of students having scored less than 5 is greater than 10 OR if the average class marks is less than 6, display “Poor class performance”
c.In any other case, display “Average class performance”

=IF(COUNTIF(B4:B31,(B4:B31>8)>9),"good",IF(OR(COUNTIF(B4:B31,(B4:B31<5)>10),AVERAGE(B4:B31)<6),"poor","average"))

OK so my If statement does kinda work, it displays average in the cell. BUT if i change my data, so that the first condition is true it does not display good. Somethings Wrong and I really dont know whats the problem. Thank You

There is a problem with the COUNTIF

Try
=IF(COUNTIF(B4:B32,">=8")>9. "High", IF(OR( COUNTIF(B4:B32,"<5")>10, AVERAGE(B4:B32)<6), "Poor", "Average"))

Posted if statement |