INSTRUCTIONS:

(1) IF combined with Max; (2) look up a student to see his/her score, whether s/he is ("whether" implies IF) Max, Min, Above AVG, Lower than AVG, or At AVG.

E1 A B D E F G H 1 L M N 0 P R S U V w 1 In columns K,L,M, write ONE formula to 2 PRINT: 1. Values of this sheet; 2. Formulas of this sheet (next sheet - no print needed) display the NAME of student, if s/he 3 is the max of the corresponding item 4 Name DB E2 XL1 XL2 xLPj FinE Semester Total xLPj-Max FinE-Max Semester-Max Enter name below. Semester Tota xLPj-Pos FinE-Pos Semester-Pos 5 1 Dean 81 46 72 20 18 47 86 6 2 Marianna 53 48 81 19 7 7 39 83 Formulas P-Q-R-S above 7 3 Indray 76 35 76 20 18 48 86 P: Display the student's Semester total 8 4 Elizabeth 61 43 80 14 10 28 66 Q-R-S: Display "Max", "Min", "Above AVG", "At AVG", "Below AVG", 9 5 Matthew 40 47 50 9 0 36 63 depending on the student's position in the column for the item (Total, XLP], FinE etc) 10 6 May 56 50 64 18 16 30 80 Hint: Similar to the "grocery store" problem in Demo 5 ("is kiwi sale maximum of all") 11 7 Tamara 25 48 44 19 7 34 Q-R-S has ONLY ONE formula! So should consider mixed reference. 12 8 Aaron 64 46 63 19 18 47 97 Simple Columns Q-R-S is very similar to the "grocery example", sum, 13 9 Wen 67 48 85 19 18 44 86 EXCEPT that you're asked to do more than MAX/Min, but also >AVG, or