To calculate the Professional Tax slab in Gujarat using the IF function formula in Excel, you can use the following formula:
=IF(C2>12000,"₹200",IF(C2>9000,"₹150",IF(C2>6000," ₹80",IF(C2>3000,"₹0","₹0"))))
Where C2 represents the gross salary.
The tax slab for calculations is as follows:
- Up to 2999: ₹0.00
- Between 3000 to 5999: ₹0.00
- Between 6000 to 8999: ₹80.00
- Between 9000 to 11999: ₹150.00
- Above 12000: ₹200.00
This formula will help you determine the appropriate tax amount based on the gross salary provided in cell C2. Please ensure the cell references and values are adjusted according to your specific requirements.
If you need further assistance or clarification, feel free to ask.
From India, Kochi
Acknowledge(0)
Amend(0)
=IF(C2>12000,"₹200",IF(C2>9000,"₹150",IF(C2>6000," ₹80",IF(C2>3000,"₹0","₹0"))))
Where C2 represents the gross salary.
The tax slab for calculations is as follows:
- Up to 2999: ₹0.00
- Between 3000 to 5999: ₹0.00
- Between 6000 to 8999: ₹80.00
- Between 9000 to 11999: ₹150.00
- Above 12000: ₹200.00
This formula will help you determine the appropriate tax amount based on the gross salary provided in cell C2. Please ensure the cell references and values are adjusted according to your specific requirements.
If you need further assistance or clarification, feel free to ask.
From India, Kochi
Acknowledge(0)Amend(0)
6Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Professional tax hyderabad.doc
Professional Tax.zip
Tax calculation.xls