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.
From India, Kolkata
Acknowledge(0)
Amend(0)
From India, Kolkata
Acknowledge(0)Amend(0)
PT is applicable month-wise gross payable, if it get reduced, then PT lower slab will get effective
Acknowledge(0)Amend(0)
725Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Gross Salary(1).xls