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)
6Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.