Average the test scores, if it lower than fifty then display the average; otherwise display the student's highest score.
Students Test 1 Test 2 Test 3 Test 4 Results
Mary 25 55 75 100
Jeanne 25 75 50 0
Barbara 60 70 no no
I know how to average the scores and use the average cell as a reference, but I do not understand how to create a formula to compute two things [counting test scores OR putting the highest score] and chose one of those as an answer.