How To Put Professional Tax Slab Gujarat- If Function Formula In Excel?
=IF(C2>12000,"200",IF(C2>9000,"150",IF(C2>6000,"80 ",IF(C2>3000,"0","0"))))
c2= gross salary
slab for calculations
Upto 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
From India, Kochi
=IF(C2>12000,"200",IF(C2>9000,"150",IF(C2>6000,"80 ",IF(C2>3000,"0","0"))))
c2= gross salary
slab for calculations
Upto 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
From India, Kochi
6Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
GUJARAT PROFESSIONAL TAX W.E.F. 01-04-2013.pdf
Professional tax hyderabad.doc
Professional Tax.zip