If gross salary fluctuate one may get down from P.tax slab - In that case my P.Tax will be?

If gross salary fluctuates, one may drop into a lower P.tax slab. For example, my gross salary is 18,000, so my PTax (West Bengal) is 130. Since I was present for 21 days, my gross salary stands at Rs. 12,600. In that case, my P.Tax will be 110. I just need to know how I can put this in an Excel formula. Please help me out.

PT is applicable on a month-wise gross payable. If it gets reduced, then the lower PT slab will become effective.

Dear Friend,

Please deduct PT on the total earnings of the employee (including overtime, incentive, etc.). Use the following formula based on the total earning amount:

=IF(TotalEarning<=7500,0,IF(TotalEarning<=10000,17 5,IF(AND(TotalEarning>10000,$F$3="FEBRUARY"),300,2 00)))

Apply this formula in your Excel sheet and adjust the figures according to the tax slab in your state.

Thank you.