VIP Discount Calculation

Below are transactions from an online store. Customers can apply discount codes at checkout to reduce the price of their purchases. Only codes that include the word VIP (case-insensitive) are active, and they apply a 10% discount to the original price. Update the output cells to display the discounted price for each product. If the code is not valid, keep the original price. See Examples

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

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