ABCDEFGHIJKL
1
2
Daftar Jumlah Penjualan Bulan Januari 2026
3
4
NoTanggalMouseKeyboard Monitor FlashdiskHardiskHeadSet
Total Harian
StatusBonus
5
11/1/20261212662947
6
21/2/2026131581141364
7
31/3/2026554102733
8
41/4/202644222519
9
51/5/202614193120654
10
61/6/202612123123547
11
71/7/202655334828
12
81/8/202612114615
13
91/9/202633224721
14
101/10/202653227827
15
111/11/202665552831
16
121/12/202622444925
17
131/13/20261210337540
18
141/14/20261331321234
19
151/15/202677221423
20
161/16/2026661124837
21
171/17/20262321551762
22
181/18/20261210771946
23
191/19/20261190981855
24
201/20/202688553938
25
211/21/2026998811045
26
221/22/202622337825
27
231/23/2026112211825
28
241/24/202665882534
29
251/25/20268311031439
30
261/26/202613223617
31
Total per produk
Bunus Jan
32
Rata-rata
33
Max
34
Min
35
36
37
Status penjualan adalah keterngan Tinggi jika jumlah penjualan melebihi 50, Sedang jika antara 50-20, Rendah jika kurang dari 20
38
=IFS(I5>=50;"Tinggi";I5>=25;"Sedang";I5<25;"Rendah")
39
40
Bonus 10.000 jika penjualan lebih dari 30 barang
41
=IF(I5>30;10000;0)
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100