AP Professional Tax Calculation With Excel Formula

Dear All,

I am mentioning below the Andhra Pradesh Professional Tax Slabs. Based on this, I need the Professional Tax calculation with an Excel formula. Please assist me.

AP Professional Tax Slabs:
- Income Between Rs. 0-5000: Professional Tax is Rs. 0
- Income Between Rs. 5001-6000: Professional Tax is Rs. 60
- Income Between Rs. 6001-10000: Professional Tax is Rs. 80
- Income Between Rs. 10001-15000: Professional Tax is Rs. 100
- Income Between Rs. 15001-20000: Professional Tax is Rs. 150
- Income above Rs. 20000: Professional Tax is Rs. 200

Thanks & Regards,
Balaji.t

Professional Tax Calculation Using Excel Formula

To calculate the professional tax based on the Andhra Pradesh Professional Tax Slabs using Excel, follow these steps:

1. Open a new Excel worksheet.
2. In one column, list the income values for which you need to calculate professional tax.
3. In the adjacent column, use the following Excel formula to calculate the professional tax based on the given slabs:
- For income in cell A2 (assuming income is in column A):
- =IF(A2<=5000, 0, IF(A2<=6000, 60, IF(A2<=10000, 80, IF(A2<=15000, 100, IF(A2<=20000, 150, 200)))))
4. Drag the formula down to apply it to all income values.
5. Excel will calculate the corresponding professional tax based on the income slabs provided.

By following these steps, you can easily calculate the professional tax based on the Andhra Pradesh Professional Tax Slabs using Excel.