Intro Goal Status

This intro problem practices IF. IF checks whether a condition is true, then returns one value when it is true and another value when it is false. Update the output cells so each student row shows "Hit" when the student's score is at least as high as their goal, otherwise show "Miss". See Examples

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

Need help with IF details and syntax? Review the IF function guide first.

IF
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