Grade book - Replacing lowest of 1st 3 tests with another score.

**windym23** · 08-28-2011, 09:22 PM

I have a professor that gives 3 exams plus a final. He will replace the lowest of the first three exams with the higher of either the average of the first 3 or the final exam score. Is there a formula to figure this out? It can take up several cells if need be. I just want it to do it for me.

**p24leclerc** · 08-28-2011, 10:32 PM

Look at the attached file. In column C, you'll find the formulas. It really depends on the placement of other cells.

Please Login or Register  to view this content.

**jeffreybrown** · 08-28-2011, 10:45 PM

@p24leclerc,

I was looking at this thread and then saw your post...

Just thought I would pass on an observation, you seemed to have missed the absolute references and some references were off...

=IF(B2=MIN($B$2:$B$4),MAX(AVERAGE($B$2:$B$4),$B$5),B2)