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.
Look at the attached file. In column C, you'll find the formulas. It really depends on the placement of other cells.
=IF(B3=MIN(B3:B5);MAX(AVERAGE(B2:B4);B5);B3)
@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)
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
You are absolutely right. I overlook that.
Thanks Jeffrey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks