Neco 2018 Computer Studies Question 37

In a spreadsheet, the commission for a salesperson is calculated on total sales (UnitsSold × UnitPrice) as follows: 5% on the first \(10{,}000\) Naira, 7% on the next \(10{,}000\) Naira, and 10% on any amount above \(20{,}000\) Naira. Write a single Excel formula (using nested IF) that placed in cell D2 returns the commission for the row, assuming UnitsSold is in B2 and UnitPrice in C2. Then, using the data below, compute the total commission paid to all three salespersons.\n\n| Salesperson | UnitsSold (B) | UnitPrice (C) |\n|-------------|---------------|---------------|\n| Alice | 120 | 80 |\n| Bob | 200 | 60 |\n| Carol | 150 | 90 |