 How to put professional tax slab - If function formula in excel? - CiteHR #query{background:#ebf5fd;color:#4f4f4f;letter-spacing:1px;padding:5px;border:1px #001b31 solid;text-indent:3%;font-size:small} form#search_query{color:#fdfcfb;text-align:left;margin:0} Tarte_ambarish
Corporate Trainer Sumit Jhawar
Manager Hr Nilendrachand
Human Resource
Praveenr22
Accountant
Bhavishya.kr
Central Mis
+1 Other

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Hi All, I should put professional tax slab in excel. Slab for professional tax in bangalore are till 3000 its nil;from 3000 to 4999 its 30Rs; from 5000 to 7999 its 60Rs; from 8000 to 9999 its 100 Rs; from 10000 to 14999 its 150 Rs; above 15000 its 200R s. So please guide me to apply this slab into formula in excel sheet.
Pl use this formula, =IF(A1>=15000,"200",IF(A1>=10000,"150",IF(A1>=8000,"100",IF(A1>=5000,"60",IF(A1>=3000,"30",IF(A1>=0,"0")))))) I hope this solves your query Regards, Nilendra
Good Nilendra, but if we remove " " those symbol we can sum it, otherwise total sum difficult to do. Ramesh P.
hI, Even im trying to apply the same formula but its not happening , but my salary slab is different so please help to create IF formula . My Salary slab of Kolkata IS 0-8500 is Nil, 8501-10000-90, 10001-15000 IS 110, 15001-25000 is 130, 25001-40000 is 150 and above 40000 is 200
Hi Debanjana Raha,
The PTax formula for West Bengal is as below
IF(AND(M8>8501,M8<10001),90,IF(AND(M8>10001,M8<150 01),110,IF(AND(M8>15001,L8<25001),130,IF(AND(M8>25 001,M8<40001),150,IF(M8>40001,200,0)))))
Note : M8 is the Gross Salary Cell
Hi Praveen,
The PTax formula for Karnataka is as below
IF(AND(M8>3001,M8<5000),30,IF(AND(M8>5000,M8<8000) ,60,IF(AND(M8>8000,L8<10000),100,IF(AND(M8>10000,M 8<15000),150,IF(M8>15000,200,0)))))

[QUOTE=Sumit Jhawar;2226293]Hi Debanjana Raha,
The PTax formula for West Bengal is as below
IF(AND(M8>8501,M8<10001),90,IF(AND(M8>10001,M8<150 01),110,IF(AND(M8>15001,L8<25001),130,IF(AND(M8>25 001,M8<40001),150,IF(M8>40001,200,0)))))
Note : M8 is the Gross Salary Cell
Hi Praveen,
The PTax formula for Karnataka is as below
IF(AND(M8>3001,M8<5000),30,IF(AND(M8>5000,M8<8000) ,60,IF(AND(M8>8000,L8<10000),100,IF(AND(M8>10000,M 8<15000),150,IF(M8>15000,200,0)))))
Note : M8 is the Gross Salary Cell

Hi Debanjana Raha,
The PTax formula for West Bengal is as below
IF(AND(M8>8501,M8<10001),90,IF(AND(M8>10001,M8<150 01),110,IF(AND(M8>15001,L8<25001),130,IF(AND(M8>25 001,M8<40001),150,IF(M8>40001,200,0)))))
Note : M8 is the Gross Salary Cell
Hi Praveen,
The PTax formula for Karnataka is as below
IF(AND(M8>3001,M8<5000),30,IF(AND(M8>5000,M8<8000) ,60,IF(AND(M8>8000,L8<10000),100,IF(AND(M8>10000,M 8<15000),150,IF(M8>15000,200,0)))))
Note : M8 is the Gross Salary Cell

While the usage if Multiple IFs is apt in this case, I'd rather use VLOOKUP with 1 (TRUE) here.
Creating a data table with the given data and then applying VLOOKUP would save a few minutes I think.

Hi All, Can you please help me with PT formula in one cell for all state. if i select the state and inter the gross then it shoud be calculate accordingly basis on state and gross.
Hi All,
Listed Under 