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:
OFF: This reward is given to customers who spent $ last year.
OFF: This reward is given to customers who have been making purchases for more than two years and spent more than $ last year.
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 months.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
