calculation of professional tax

Normally professional tax in not applicable all over the country but there are some state where the government take professional tax 

Karnataka,
Bihar, 
West Bengal,
AndhraPradesh,
Telangana, 
Maharashtra,
Tamil Nadu, 
Gujarat,
Assam, 
Kerala,
Meghalaya,
Odisha, 
Tripura, 
Madhya Pradesh
Sikkim.

 Professional tax caluclted on two basis  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

Replace negative into positive

Replace all Negative value in positive. Here is the table

1. Select the whole negative row

2. Press Ctrl+F

3. Click on Replace All.

Click on Ok 

Now all the negative values are changed into Positive.

PMT formula

Basically PMT formula is use to calucalt the amount of loan.We will try to uderstand the formula throgh the Example. 

Suppose we have taken loan form the bank and we have to find out the EMI Amount. 

Syntex

=pmt(rate,nper,pv[fv],[type])

 rate  = rate is The percent which is fix by the bank on the loan

 nper = nper is the time which is in month like 5 years(60 months)

 pv    = pv is present value (we can say the loan which is taken by us)

The value will show in minus because we are paying the money.