A clothing retail store offers a discount at the rate of 10% on the customer bill if the purchase exceeds $100. The owner of the store wishes to know the total amount that has been discounted on the customers' purchases on a particular day. The purchase amount for each of the 12 customers who visited the store on that day is given below. Use the IF and SUM functions to find the total amount discounted on this single day purchases.

Question

Quizplus · Accepted Answer

The Answer of A clothing retail store offers a discount at the rate of 10% on the customer bill if the purchase exceeds $100. The owner of the store wishes to know the total amount that has been discounted on the customers' purchases on a particular day. The purchase amount for each of the 12 customers who visited the store on that day is given below. Use the IF and SUM functions to find the total amount discounted on this single day purchases.

A Clothing Retail Store Offers a Discount at the Rate