QUESTION:

REATE THE EXCEL FORMULA FOR THE FOLLOWING RESTRAINTS $($COLUMN B IS MEMBER, PURCHASE IN PAST YEAR IS COLUMN D AND PURCHASE IN PAST SIX MONTHS IS COLUMN E

Campaign $6$: Give members who have purchased more than $$1000$ in the past year $40\%$ off, give the rest of members $20\%0$ff$,$ give nonmembers who have purchased more than $$500$ in the past six months $10\%.$

Campaign $7$:

$40\%$ for member whose past year purchase is between $$1500-$$$2000$

$30\%,$ $$1000-$$$1500$

$20\%,$ $$500-$$$1000$

$15\%,$ $$250-$$$500$

$10\%,$ $$100-$$$250$

$0,0-$$$100$

Campaign $8$: give a cash back of $5\%$ of their purchase in the past $6$ months with $$40$ maximum cash back, calculate the cash back value for each customer.

Campaign $9$: give a cash back of $5\%$ of their purchase in the past $6$ months with $$5$ minimum cash back, calculate the cash back value for each customer.