Formula In Excel - Professional Tax - CiteHR
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...
Hi,
I have newly joined in a company where i need to manage the payroll of more than 500 employees.I am managing the payroll in excel sheet.I am putting PT manually.Can anybody halp me to calculate PT - professional tax by using formula.
In karnatka rs.0/- - rs.9999/-PT is nil
rs.10000/- - rs.15000/-PT is rs.150/-
rs.15000/- and above PT is rs.200/-
how i ll manage this structure in excel by applying formula?

try this =IF(D10>=15000,200,(IF(D10>=10000,150,IF(D10<=9999,0)))) d10 is the reference for your salary figure All the best!!!!! 500 employees in excel is a big task :)
Dear Viraj, Thanx a lot. Probably I need yr help in future also to generate the payroll. pl keep in touch. Thnx n Rgds, Sukanya
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™