Calculation of Professional Tax

                                              Calculation of Professional Tax 

Herea are two method of calculation of professional tax.
1. Professional Tax on Total Salary.
2. Professional Tax on Basis Salary.

So Here is the Exanple

Formula:                                                                                                                                 =IF((E7>=$A$2)*(E7<=$B$2),$C$2,IF((E7>=$A$3)*(E7<=$B$3),$C$3,IF((E7>=$A$4)*(E7<=$B$4),$C$4,IF((E7>=$A$5)*(E7<=$B$5),$C$5,IF((E7>=$A$6)*(E7<=$B$6),$C$6))))) 

($ it is the sign that fix the cell, select the cell and press F4 or Fn+F4)

2. Calculation of professional Tax according to the basis salary

Salary of Employee's
Emp. Code	Basic	HRA	Conveyance	Total Salary	If Professional Tax on Basic Salary		Salary Range		Professional Tax Slab
1	3,000.00	1,500.00	800.00	5,300.00	Nil		-	3,000.00	Nil
2	5,000.00	2,500.00	800.00	8,300.00	130.00		3,001.00	4,500.00	70.00
3	4,100.00	2,050.00	800.00	6,950.00	70.00		4,501.00	5,500.00	130.00
4	15,000.00	7,500.00	800.00	23,300.00	800.00		5,501.00	10,000.00	200.00
5	12,540.00	6,270.00	800.00	19,610.00	800.00		10,001.00	1,00,000.00	800.00
6	14,500.00	7,250.00	800.00	22,550.00	800.00
7	3,000.00	1,500.00	800.00	5,300.00	Nil
8	30,000.00	15,000.00	800.00	45,800.00	800.00
9	16,500.00	8,250.00	800.00	25,550.00	800.00
10	45,000.00	22,500.00	800.00	68,300.00	800.00
11	40,000.00	20,000.00	800.00	60,800.00	800.00

  

                                              Professional Tax on Total Salary

Salary of Employee's
Emp. Code	Basic	HRA	Conveyance	Total Salary	If Professional Tax on Total Salary		Salary Range		Professional Tax Slab
1	3,000.00	1,500.00	800.00	5,300.00	Nil		-	6,000.00	Nil
2	5,000.00	2,500.00	800.00	8,300.00	70.00		6,001.00	15,000.00	70.00
3	4,100.00	2,050.00	800.00	6,950.00	70.00		15,001.00	25,000.00	130.00
4	15,000.00	7,500.00	800.00	23,300.00	130.00		25,001.00	30,000.00	200.00
5	12,540.00	6,270.00	800.00	19,610.00	130.00		30,001.00	1,00,000.00	800.00
6	14,500.00	7,250.00	800.00	22,550.00	130.00
7	3,000.00	1,500.00	800.00	5,300.00	Nil
8	30,000.00	15,000.00	800.00	45,800.00	800.00
9	16,500.00	8,250.00	800.00	25,550.00	200.00
10	45,000.00	22,500.00	800.00	68,300.00	800.00

Formula is =  =IF((E7>=$A$2)*(E7<=$B$2),$C$2,IF((E7>=$A$3)*(E7<=$B$3),$C$3,IF((E7>=$A$4)*(E7<=$B$4),$C$4,IF((E7>=$A$5)*(E7<=$B$5),$C$5,IF((E7>=$A$6)*(E7<=$B$6),$C$6)))))