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
From India, Hyderabad
Acknowledge(0)
Amend(0)
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
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Gurugram
Acknowledge(0)Amend(0)
46To 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.
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
AP New Professional Tax slabs w.doc