Question: Use a Nested IF function to complete the customer reward column. Do not change the order of the criteria. The output and criteria are listed

Use a Nested IF function to complete the customer reward column. Do not change the order of the criteria. The output and criteria are listed below:
35% OFF: This reward is given to customers who spent $25 last year.
25% OFF: This reward is given to customers who have been making purchases for more than two years and spent more than $1000 last year.
50% OFF: This reward is given to customers who have been purchasing from the store for more than one year but have not made a purchase in the past 12 months.
8% OFF: This reward is given to any cus

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!