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,
Copy the formula to the last employee.