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.

Rather than type in the values, reference the appropriate cells in I$5$:I$7$ for the values. Use the fill handle to copy the formula down through G$16.$