In a spreadsheet, the unit price of a product is stored in cell $C2$ as ₦150. The table records monthly units sold in column $B$ (rows 5 to 8). The discount rate in column $D$ is determined by the units sold:

- If units sold $\ge 500$ → 10 %
- If units sold $\ge 300$ but

Question

In a spreadsheet, the unit price of a product is stored in cell $C2$ as ₦150. The table records monthly units sold in column $B$ (rows 5 to 8). The discount rate in column $D$ is determined by the units sold:

- If units sold $\ge 500$ → 10 %
- If units sold $\ge 300$ but < 500 → 5 %
- Otherwise → 0 %

Final revenue for each month is calculated as $ \text{Units Sold} \times \text{Unit Price} \times (1 - \text{Discount Rate}) $.

Write the formula that should be entered in cell $E5$ for the month of June (where $B5 = 420$) using absolute reference for the unit price and a nested IF to obtain the discount rate, and state the resulting revenue for June.

Accepted Answer

=B5*$C$2*(1-IF(B5>=500,0.10,IF(B5>=300,0.05,0))) ; 59,850

Gce Model Questions Vol1 2025 Computer Studies Question 2

Answer Options

About This Question

Master the Exam!