need help with MY FORMULA

M

maxlive

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" )))
 
D

Dave F

You seem to have extraneous characters in your formula.

Try:

=IF(COUNTIF([range]="p")=7,"Distinction",IF(COUNTIF(C8:G18="p")=5,"Merit",IF(COUNTIF(C8:E8="p")=3,"NOT YET ACHIEVED")))

I'm not sure what the range for your first COUNTIF should be, as you don't
give one in your original formula. Also, the ranges given in your 2nd and
3rd COUNTIFs are not consistent with each other, so you should look at that
as well.

Dave
 
Top