Intro Score Bands

This intro problem practices IFS. IFS checks conditions in order and returns the value for the first true condition. Update the output cells so scores of 90 or more return "A", scores of 80 or more return "B", scores of 70 or more return "C", and lower scores return "D". See Examples

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

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

IFS
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