Hi. I'm a newbie in this field. please help me.
When the result in the cell hits 97% or more, the remark "Independent" comes out.
The same happens with 89%. The remark "Frustration" comes out.
But that doesn't happen with "Instructional". Sometimes it comes out, sometimes not.
please check this formula:
=IF(COUNT(A8)=0,"",IF(A8>(96%),"Independent",IF(A8=(90%),"Instructional",IF(A8=(91%),"Instructional",IF(A8=(92%),"Instructional",IF(A8=(93%),"Instructional",IF(A8=(94%),"Instructional",IF(A8=(95%),"Instructional",IF(A8=(96%),"Instructional",IF(A8<(90%),"Frustration",""))))))))))
Bookmarks