Find Average of highest scoring in two tests (Excel-2007)
Find Average as average of highest scoring two tests in Column E
To compute average as average of highest scoring 2 tests in column E,
Enter the formula, =MAX(B1+B2,B1+B3,B2+B3)/2
Wednesday, May 5, 2010
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment