**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 |