Hello. I am having a problem coming up with a formula to average a set of numbers dropping the lowest of the numbers, then giving equal weight to the remaining 3 numbers. I am a beginning Excel user and cannot figure out how to do this. Example, A1, 95; B1, 80; C1, 70; D1, 60. The value in D1 would be dropped and (95+80+70)/3=81.7 would be the average in cell F1 that I would want calculated by a formula. I just don't seem to be able to figure this out. Any help would be so appreciated! Thank You.![]()
Bookmarks