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.