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)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Gross Salary(1).xls