Procedure:
Step 1 – Open a new blank worksheet in LiberOffice Calc.
Step 2 – Enter the following details in respective cells.
|
A |
B |
1 |
Employees |
Yearly salary |
2 |
Fijo |
855000 |
3 |
Joshy |
650000 |
4 |
Roby |
720000 |
5 |
Bose |
425000 |
6 |
Prince |
570000 |
7 |
Binoy |
380000 |
Step 3 – Select the range A2: A7, From Data Tools menu, select ‘Name a Range’ and give name as “Employees” and click (OK) button.
Step 4 – Enter the text /formula in the following cells.
|
C |
1 |
Advance Tax |
2 |
= IF (B2>=500000, B2*10%, 0) |
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Step 5 – Copy formula to C3: C7 to the last employee.
Step 6 – Enter “Total Advance Tax” in cell B8 and enter the formula ‘‘SUM C2: C7” to get total amount.
Output:
Fijo |
85500 |
Joshy |
65000 |
Roby |
72000 |
Prince |
57000 |