On the CustomerAnalysis worksheet, in cell G$4,$ enter a Nested IF function that will return values based on the following:

If a customer is a club member and has been deemed a high value customer based on their

last transaction, she would like them to get $20\%$ off.

If they are not a member but are still deemed a high value customer, she would like them to get $15\%$ off.

All other customers will receive a $10\%$ off coupon.