need help with MY FORMULA
 

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

need help with MY FORMULA
 

You seem to have extraneous characters in your formula.

Try:

=IF(COUNTIF([range]="p")=7,"Distinction",IF(COUNTIF(C8:G18="p")=5,"Me rit",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
--
Brevity is the soul of wit.


" wrote:

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