Grade Book project

[Emma]

I am trying to complete an assignment and have reached a
point where I am totally lost. Where the problem has come
up is when I need to have the grade on a term project
replace the lowest exam grade if the term project grade
is higher than the lowest test grade. The student will
take 3 exams worth 30% of their final grade. How do I go
about comparing the term grade (column O) with the 3 exam
grades (columns B,C,D). And how do I drop the lowest
grade and use the term project grade if it meets the
criteria? The average exam grade is column E, the minimum
exam grade is column F, and the max exam grade is column
G. I would really some help with this problem.
Thanks,
Emma

 

[Tom Ogilvy]

the formula for row 2 would be

=if(O2>min(B22),Sum(B22)-Min(B22)+O2,Sum(B22))

 

[Tom Ogilvy]

of course to make that an average formula

=if(O2>min(B22),Sum(B22)-Min(B22)+O2,Sum(B22))/3

or to round it

=Round(if(O2>min(B22),Sum(B22)-Min(B22)+O2,Sum(B22))/3,1)

 

[Emma]

Thank you for your help. With a minor adjustment I was
able to complete the worksheet and arrive at the answers
required to complete the grade book.