Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
321 views
in Spread Sheet by (27.3k points)
closed by

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 (25.6k points)
selected by
 
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

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...