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
6Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Professional tax hyderabad.doc
Professional Tax.zip
Tax calculation.xls