Please help me with the formula in Excel

Copper Contributor

I need a formula, if in cell I2;I3;I4;I5;I6 of grades at least 70% are rated “5”, and others are “4” and “3” the total grade is “5”.
Score “4” - if at least 95% received positive ratings, of which at least 60% received ratings of “5” and “4”, and others - “3”;

2 Replies
You question doesn't make sense.
Look, I need a formula that will calculate this: I have 10 ratings, of which 7 are “5” and 3 are “4”. The formula should calculate the scores if at least 70% have a score of “5”, the rest - “4” and “3”, the total score is “5”. And it gives 5.