Looking for a way to populate cells based off multiple conditions

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