How to put professional tax slab - If function formula in excel?

Hi all,

I need to input the professional tax slab in Excel for Bangalore. The tax slabs for professional tax in Bangalore are as follows:
- Up to 3000: nil
- 3000 to 4999: 30 Rs
- 5000 to 7999: 60 Rs
- 8000 to 9999: 100 Rs
- 10000 to 14999: 150 Rs
- Above 15000: 200 Rs

Could you please guide me on how to apply this tax slab into a formula in an Excel sheet?

Please 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 the quotation marks, we can sum it; otherwise, it is difficult to calculate the total sum.

Ramesh P.

Hi,

Even I'm trying to apply the same formula, but it's not happening. My salary slab is different, so please help create an IF formula.

My salary slab for Kolkata is as follows:
- 0-8500: Nil
- 8501-10000: 90
- 10001-15000: 110
- 15001-25000: 130
- 25001-40000: 150
- above 40000: 200

Thank you for your assistance.

Hi Debanjana Raha,

The PTax formula for West Bengal is as follows:

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 follows:

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

I have corrected the spelling, grammar, and formatting of your message. Let me know if you need further assistance.

Hi Debanjana Raha,

The PTax formula for West Bengal is as follows:

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 represents the Gross Salary Cell.

Hi Praveen,

The PTax formula for Karnataka is as follows:

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 represents the Gross Salary Cell.

While the usage of 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 the PT formula in one cell for all states? If I select the state and enter the gross, it should be calculated accordingly based on the state and gross.

Hi all,

The PTax formula for Madhya Pradesh is as follows:

IF(AND(N11>1, W11<18749), 0, IF(AND(N11>18749, W11<25000), 125, IF(AND(N11>24999, W11<33334), 167, IF(AND(N11>33333, W11<120000), 208, 0))))

I have corrected the spelling, grammar, and punctuation errors in your input. The formula is now properly formatted for better readability. Let me know if you need further assistance.

Please help me with professional tax calculation for Andhra Pradesh state. The tax slabs for gross salary are as follows:

- For gross salary between 15000 to 20000, the tax is 150.
- For gross salary above 20000, the tax is 200.
- For gross salary below 15000, the tax is "0".

Could you please provide me with a solution for this?

Formula for professional tax for Andhra Pradesh. Details already given above, sir.

Hi All,

Can you please help me with the PT formula in one cell for all states? If I select the state and enter the gross amount, it should calculate accordingly based on the state and gross income.

=IF(AND(AA$1="Feb PT", X2>10000), 300, IF(X2>10000, 200, IF(AND(X2>7500, Q2:Q31="Male"), 175, 0)))

AA$1 = WRITE IN CELL FEB PT
X2 = SALARY WAGES
SELECT GENDER ROW

THIS IS MAHARASHTRA PT SLAB

=IF(J3="Female", CHOOSE(MATCH(W3,{0,25001},1), 0,200), CHOOSE(MATCH(W3,{0,7500,10000},1), 0,175,200))

SELECT GENDER CELL
W3 = SALARY WAGES

@Debanjanaraha

=IF(AND(M8>8501, M8<=10000), 90, IF(AND(M8>=10001, M8<=15000), 110, IF(AND(M8>=15001, M8<=25000), 130, IF(AND(M8>=25001, M8<=40000), 150, IF(M8>=40001, 200, 0)))))