Forum Discussion

sashko_05's avatar
sashko_05
Copper Contributor
Mar 06, 2024

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 at least 60% received ratings of “5” and “4”, and others - “3”;

Excel
    • sashko_05's avatar
      sashko_05
      Copper Contributor
      Mar 06, 2024
      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.

Share