Mar 05 2024 11:59 PM
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”;
Mar 06 2024 12:34 AM