EXCEL FORMULA FOR PROFESSIONAL TAX

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

Replies (5)

Dear Asif,

According to your requirement, I made excel sheet with sample data 

I hope it will more help to you..........

with regards,

Baskar.V

Open excel formula for professional tax

I require Professional Tax Wokring Format. Please help me for this

I require  all state professional Tax working formula in my excel sheet.

Please help me for this

 

Search each and every 29 States Professional Tax Excel Sheet And Combined in One Excel Sheet by yourself 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details