Forum Discussion
sashko_05
Mar 06, 2024Copper Contributor
Please help me with the formula in Excel
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 a...
Harun24HR
Mar 06, 2024Bronze Contributor
You question doesn't make sense.
- sashko_05Mar 06, 2024Copper ContributorLook, 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.