+1 Other

**Cite.Co**is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network

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.

From India, Bangalore

From India, Bangalore

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.

From India, Bangalore

From India, Bangalore

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

From India, Kolkata

From India, Kolkata

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)))))

From India, Kolkata

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)))))

From India, Kolkata

[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

From India, Kolkata

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

From India, Kolkata

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

From India, Kolkata

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

From India, Kolkata

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.

From India, Mumbai

Creating a data table with the given data and then applying VLOOKUP would save a few minutes I think.

From India, Mumbai

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.

Add the url of this thread if you want to cite this discussion.

Add the url of this thread if you want to cite this discussion.

#Listed In: professional tax slab salary slab west bengal tax slab professional tax City-India-Bangalore Country-India