G
Guest
any one out there to help me
MY FORMULA
=` IF
(countif(8:18),:=;="p")=7,"Distinction",IF(countif(C8:G18,"p",,)=5,"Merit",IF(Countif(C8;E8."p")=3,"NOT YET ACHIEVED" )))
MY FORMULA
=` IF
(countif(8:18),:=;="p")=7,"Distinction",IF(countif(C8:G18,"p",,)=5,"Merit",IF(Countif(C8;E8."p")=3,"NOT YET ACHIEVED" )))