Calculating Professional Tax Slab in Gujarat Using Excel
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.
Tax Slab for Calculations
- 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
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.
Tax Slab for Calculations
- 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
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.