Asst.manager -hr
Hr Consultant

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
If gross salary fluctuate one may get down from P.tax slab. For eg. My gross salary is 18000 so my PTax(West Bengal) is 130 and since I was present for 21 days my gross salary is standing to Rs.12600.In that case my P.Tax will be 110. I just need to know how can i put this in excel formula.Please help me out.
From India, Kolkata
PT is applicable month-wise gross payable, if it get reduced, then PT lower slab will get effective

Dear Friend,
PT deduct on total earning of the employee (Including Overtime,Incentive etc...), Put your formula on Total Earning amount.
Ex :
=IF(TotalEarning<=7500,0,IF(TotalEarning<=10000,17 5,IF(AND(TotalEarning>10000,$F$3="FEBRUARY"),300,2 00)))
Use this formula in your excel and change the figures as per your state slab.

From India, Mumbai
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™