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
Shipping Priority Check
Update the output cells so that each order’s status in column E is set to "Flag" if ANY of the following is true for that order: (1) the Qty in column D is 100 or more, (2) the Shipping text in column C contains the text "Rush" anywhere (case-insensitive), or (3) the Shipping text in column C contains the text "Exp" anywhere (case-insensitive). If none of these are true, return "OK". See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
A1 expected value: *
A1
fx
This cell cannot be edited
