Logical Function.xlsx

	A	B	C	D	E	F	G	H	I
1	Shopping Destination
2	Customer Name	Shopping Amount	No. of Brands	IF	IF OR	IF AND	Nested IF	Total Discount	Total Shopping
3	Ajay Dongra	34000.00	7	6800.00	1700.00	3400.00	1000.00	12900.00	21100.00
4	Amit Bhandari	12000.00	5	1200.00	600.00	0.00	200.00	2000.00	10000.00
5	Ankit Mishra	13000.00	4	1300.00	0.00	0.00	200.00	1500.00	11500.00
6	Birju Yadav	14000.00	3	1400.00	0.00	0.00	200.00	1600.00	12400.00
7	Deepak Tijori	26000.00	5	2600.00	1300.00	2600.00	500.00	7000.00	19000.00
8	Nayan Gupta	18500.00	3	1850.00	0.00	0.00	200.00	2050.00	16450.00
9	Rahul Trivedi	35000.00	8	7000.00	1750.00	3500.00	1000.00	13250.00	21750.00
10	Raj Narayan Singh	20000.00	7	2000.00	1000.00	0.00	500.00	3500.00	16500.00
11	Ratan Sukla	23000.00	4	2300.00	0.00	0.00	500.00	2800.00	20200.00
12	Suraj Singhania	18000.00	5	1800.00	900.00	0.00	200.00	2900.00	15100.00
13
14	Function	IF	IF OR		IF AND		Nested IF
15	Condition	Shop>=30000	Shop>=25000	Brand>=5	Shop>=25000	Brand>=5	Shop>=30000	Shop>=20000	Shop>=10000
16	If True	20%	5%	5%	10%	10%	1000	500	200
17	If False	10%	0	0	0	0	0	0	0
18
19				Customer Name	Tot Shopping	Tot Brand
20				Deepak Tijori	19000.00	5
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
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