Question

ABC Ltd categorises their salesmen into four on the basis of sales targets achieved in each quarter. The criteria and sales are given below.

Performance criteria

Total sales – Grade 

More than 100000 – Excellent 

50000-100000 – Good 

30000-50000 – Average 

Less than 30000 – Bad

Answer 1

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 in E2 to get total sales = SUM (B2: D2) Copy the formula to the last employee.

Step 4 – Enter the formula in F2 to get the commission = IF(E2 >= 100000, “EXCELLENT”, IF (E2 >= 50000, “GOOD”, IF (E2 >= 30000, 

“AVERAGE”, “BAD”))) 

Copy the formula to the last employee. 

Output:

Ramesh	BAD
Suresh	GOOD
Mahesh	AVERAGE
Rajesh	GOOD
Sukesh	GOOD