Student Admission Exams

crown

In order to be admitted to a prestigious university, students must take 3 tests. The students' 3 test scores are added together to calculate their total score. The students with the 3 highest total scores are admitted. Update the output cells so that each student's Admission status ("Yes" or "No") is displayed. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

RANK IF SUM
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50