Promo Eligibility Check

crown

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.

AND IF VLOOKUP XLOOKUP LEFT LEN
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