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

From India, Kochi
vrgajjar
6

=IF(C2>=12000,"200",IF(C2>=9000,"150",IF(C2>=6000,"80 ","0")))
From India, Ahmadabad
Community 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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.