Professional Tax calculation Gujarat- Formula In Excel

pjofficial

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

vrgajjar

=IF(C2>=12000,"200",IF(C2>=9000,"150",IF(C2>=6000, "80 ","0")))

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute