Loyalty Points Bonus

Update the output cells so that each customer row shows the correct total points based on these rules: 1) Base points are equal to Purchases multiplied by Rate. 2) Bonus points are equal to one extra point for every full block of 10 base points (ignore any remainder). 3) The displayed total points must be the sum of base points and bonus points, adjusted to the nearest multiple of 10. 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