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
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Vrgajjar
Manager, Human Resources
Pjofficial
Hr&admin Executive

Use factoHR and automate your HR processes

Mobile-first hire to retire HR and Payroll software that automates all HR operations and works as a catalysts for your organisational growth.



vrgajjar
6

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

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.







About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server