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