Compare a score to the middle value
You're analyzing a class quiz: the five scores are already entered in A2:A6, and you want to know whether the first student's score in A2 sits above, below, or right at the middle of the class. Fill the vs Middle cell B2 — return Above, Below, or Equal.
Your solution should use cell references so it updates automatically when Test Case input values change.
Test case
1
2
3
Reset
Submit
A
B
C
D
E
F
G
1
2
3
4
5
6
7
8
9
10
○ Ready Enter formula in highlighted cells, then click Submit.
Test case
1
2
3
Reset
Submit
A
B
C
D
E
F
G
1
2
3
4
5
6
7
8
9
10
○ Ready Enter formula in highlighted cells, then click Submit.
Notes
Use MEDIAN for the middle value of an unsorted list. Lock the median range with $ if you plan to fill the formula down.
Function guide
FAQ
How do I compare a value to the median in Excel?
Combine IF with MEDIAN, for example =IF(A2>MEDIAN($A$2:$A$6),"Above",IF(A2<MEDIAN($A$2:$A$6),"Below","Equal")).
Why lock the median range with $?
Absolute references keep the full list fixed when you fill the formula down to other rows.