Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc
Step 2 – Enter the following details in the following cells.
Step 3 – Enter the following formula in respective cells
Cell |
Formula |
C2 |
=B3*50% |
E2 |
=B3*5% |
F2 |
= SUM (B3:E3) |
G2 |
= B3*8% |
H2 |
=F3 - G3 |
Step 4 – Copy the formula down up to the last employee
Output:
Name of Employee |
Net salary |
Adarsh |
12760 |
Alwin paul |
12613 |
Amal mohan |
12760 |
Amarnath |
12098.50 |
Anurag |
14230 |