Question

Calculate Income Tax of following employees based on the following criteria.

Name of employee	Sex	Total income
Manoj	Male	3,00,000
Preveen	Female	4,50,000
Naveen	Male	7,00,000
Riya	Female	6,70,000
Rohit	Male	5,00,000
Latha	Female	4,00,000
Arya	Female	8,60,000

Conditions 

1. Tax rate is 40% of Total taxable Income. 

2. For male, standard deduction is 150,000 

3. For female, if taxable income is less than or equal to Rs.4,00,000, then the standard deduction is 2,00,000, otherwise 1,50,000

Answer 1

Procedure: 

Step 1 – Open LibreOffice Calc worksheet Application → Office → LibreOffice calc 

Step 2 – Enter the given details in the given range

Step 3 – Calculation of Tax Enter the formula in D2 cell and drag with the fill handle up to D8 = IF(B2 = “Male”, (C2 – 150000)*40%, IF (AND(C2 = “Female”, C2 <= 400000), (C2 – 200000)*40%, (C2 – 150000)*40%)) 

Output:

Name of Employee	Tax
Manoj	60,000
Praveena	1,20,000
Naveen	2,20,000
Riya	2,08,000
Rohit	1,40,000
Latha	80,000
Arya	2,84,000