Question

The monthly sales effected by 6 salesmen are given below.

Name	January	February	March
Anu	2000	2800	30000
Binu	3200	4000	3800
Manu	1900	3300	3500
Vinu	4200	4800	5100
Sinu	3100	2800	4600
Tinu	2500	3100	3800

Calculate the commission earned by each salesman on the basis of the following rules.

Total sales	Commission
Less than 8000	Nil
8000-10000	5%
10000-12000	8%
More than 12000	10%

Answer 1

Procedure: 

Step 1 – Open a new blank worksheet in LibreOffice Calc. 

Step 2 – Enter the following details in the respective cells.

Step 3 – Enter the formula = SUM (B2: D2) in cell E2 to get the total sales. Copy the formula to the last employee. 

Step 4 – Enter the formula = IF (E2 >= 12000, E2 * 10%, IF (E2 >= 10000, E2*8%, IF(E2 >= 8000, E2 * 5%,0))) 

Copy the formula to the last employee.

Output:

Anu	0
Binu	880
Manu	435
Vinu	1410
Sinu	840
Tinu	470