Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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?

From India, Bangalore
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 :)
From India, Pune
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
From India, Bangalore
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™