Aleeta would like to reward certain customers with a prize based on the total amount spent...

Transcribed Image Text:

Aleeta would like to reward certain customers with a prize based on the total amount spent and total quantity of items purchased. On the Transactions worksheet, in cell C33, use the LET function to add clarity to a formula that evaluates each customer's total amount spent and total quantity of items purchased, using the sample transaction data provided, and returns Prize if they meet both criteria identified in cells E33:F33. If a customer doesn't meet the criteria, return a blank (""""). Use the following variable names in the function: Total Spent and TotalQty Copy the formula down to C42. Aleeta would like to reward certain customers with a prize based on the total amount spent and total quantity of items purchased. On the Transactions worksheet, in cell C33, use the LET function to add clarity to a formula that evaluates each customer's total amount spent and total quantity of items purchased, using the sample transaction data provided, and returns Prize if they meet both criteria identified in cells E33:F33. If a customer doesn't meet the criteria, return a blank (""""). Use the following variable names in the function: Total Spent and TotalQty Copy the formula down to C42.