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. Display your use of the IF and SUM functions and calculate the total amount discounted on this single day purchases. $$\begin{array}{cc}
\text { Customer } & \text { Purchase Amount (\$) } \
1 & 123 \
2 & 114 \
3 & 43 \
4 & 123 \
5 & 32 \
6 & 72 \
7 & 119 \
8 & 52 \
9 & 89 \
10 & 116 \
11 & 176 \
12 & 9

\end{array}$$

Question

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. Display your use of the IF and SUM functions and calculate the total amount discounted on this single day purchases. $$\begin{array}{cc}
\text { Customer } & \text { Purchase Amount (\$) } \
1 & 123 \
2 & 114 \
3 & 43 \
4 & 123 \
5 & 32 \
6 & 72 \
7 & 119 \
8 & 52 \
9 & 89 \
10 & 116 \
11 & 176 \
12 & 9

\end{array}$$

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. Display your use of the IF and SUM functions and calculate the total amount discounted on this single day purchases. $$\begin{array}{cc}
\text { Customer } & \text { Purchase Amount (\$) } \
1 & 123 \
2 & 114 \
3 & 43 \
4 & 123 \
5 & 32 \
6 & 72 \
7 & 119 \
8 & 52 \
9 & 89 \
10 & 116 \
11 & 176 \
12 & 9

\end{array}$$

A Clothing Retail Store Offers a Discount at the Rate