EXCEL FORMULA FOR PROFESSIONAL TAX

Asif Khan (Taxation executive) (410 Points)

28 February 2011  

HI FREINDS

I WANT TO CALCULATE THE PROFESSIONAL TAX DEDUCTED BY THE COMPANY FROM THE SALARY OF THE EMPLOYEES. THERE ARE AROUND 500 EMPLOYEES IN THE COMPANY AND THE PROFF TAX SLAB IS AS FOLLOWS  SALARY UPTO 3000 NO PT, FROM 3000 TO 3500 PT = 60 RS, FROM 3501 TO 5000 PT=120, FROM 5001 TO 10000  PT=175 RS, ABOVE 10000 PT=200. I HAVE TO FEED THE PT DEDUCTED FROM THE SALARIES IN AN EXCEL SHEET CONTAINING THE LIST OF 500 EMPLOYEES. IS THERE ANY FORMULA SO THAT THE EXCEL WOULF AUTOMATICALY CALCULATE THE PT FOR THE ENTIRE SALARY COLUMN AS THE SLAB.

PLS HELP ITS URGENT