# The monthly sales effected by 6 salesmen are given below.

0 votes
284 views

closed

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%

## 1 Answer

+1 vote
by (27.2k points)
selected

Best answer

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

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer