Question

Write command for the operations (i) to (iii) based on the spreadsheet below:

1. To calculate the Amount as Unit Price*Qty for each item in Column F.

2. To calculate the Rebate as 7% of Amount if Type is consumable, else calculate Rebate as 11% of Amount in Column G.

3. To calculate total Rebate across all items in cell G6.

Answer 1

1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.

2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.

3. At cell G6, type =SUM(G2: G5).