Asst.manager -hr
Hr Consultant

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™