Salary detail of 8 employees are given below. 1. Elsy Female 500000 2. Jose male 650000

Question

Salary detail of 8 employees are given below.

Develop a formula to compute tax under the following conditions. 

1. Tax rate-20% 

2. For males, Rs. 2,00,000 is allowed as standard deduction. For females, if taxable income is less than or equal to Rs. 5,00,000, then Rs. 3,00,000 is allowed as standard deduction, otherwise Rs. 2, 50,000. Use suitable logical function. 

Answer 1

Procedure:

Step 1 – Open a new blank worksheet in LibreOffice Calc 

Step 2 – Enter the following details in respective cells.

Step 3 – Enter the formula in cell E2 and copy it to the last employee. 

=IF (C2 = “MALE”, (D2-20Q000)*20%, IF (AND(C2 = “FEMALE”, D2<=500000), (D2 – 300000) * 20%, (D2-250000)*20%)) 

Output:

Name	Tax
Elsy	40,000
Jose	90,000
Rosily	20,000
Rejina	40,000
Antony	1,00,000
Jessy	30,000
George	80,0000
Baby	60,000