Hi,
I'm trying to set up a table to track students % on tests over three attempts. I have a final score column that can meet 3 conditions. I was wondering how to best populate the cells.
Condition 1 - If all attempts are less than or equal to 79 I need an output to show average of all attempts
Condition 2 - If the very first attempt is greater than or equal to 80 than output that score
Condition 3 - If attempt 2 or 3 is greater than or equal to 80 then output the value 80
Bookmarks