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
Promo Eligibility Check
Update the output cells so that each order is marked exactly "YES" or "NO" based on the following rules. For each row in B3:E9, return exactly "YES" in column F only if ALL of the following are true: (1) the value in column D is greater than or equal to the region's minimum amount listed in the table H3:I9 (2) the text in column E begins with the four uppercase letters "SAVE" (3) the text in column E contains exactly 8 characters in total. If any one of those checks fails, return exactly "NO". Assume every region in column C will appear exactly once in H3:H9. See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
A1 expected value: *
