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?
From India, Bangalore
Acknowledge(0)
Amend(0)
2I 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?
From India, Bangalore
Acknowledge(0)Amend(0)
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
Acknowledge(3)
Amend(0)
Acknowledge(3)Amend(0)
Good Nilendra, but if we remove " " those symbol we can sum it, otherwise total sum difficult to do. Ramesh P.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
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.
From India, Kolkata
Acknowledge(0)Amend(0)
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.
From India, Kolkata
Acknowledge(0)Amend(0)
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.
From India, Kolkata
Acknowledge(0)Amend(0)
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.
From India, Kolkata
Acknowledge(0)Amend(0)
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.
From India, Kolkata
Acknowledge(0)Amend(0)
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.
From India, Kolkata
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply is correct. Using VLOOKUP with TRUE can efficiently handle the professional tax slab calculation in Excel. (1 Acknowledge point)
0
0
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.
From India, Noida
Acknowledge(0)Amend(0)
From India, Noida
Acknowledge(0)Amend(0)
Hi All, The PTax formula for Madhya Pradesh is as below 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))))
From India, undefined
Acknowledge(1)
Amend(0)
From India, undefined
Acknowledge(1)Amend(0)
please help me on professional tax calculation for andhrapradesh state p tax slabs for gross salary 15000 to 20000 is 150 and 20000 above is 200 and below 15000 is "0" so please give me solution
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
formula for professional tax for andhrapradesh sir , details already given above sir,
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
Hi All, Can you please help me with PT formula in one cell for all state. if i select the state and enter the gross then it should be calculate accordingly basis on state and gross.
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-Hi All, To calculate Professional Tax in Excel based on state and gross, you can use nested IF formulas. Ensure to comply with state-specific rates and regulations. (1 Acknowledge point)
0
0
=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 MAHARASTRA PT SLAB
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
=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
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Professional Tax State Wise Slabs.doc
PROFESSIONAL TAX SLABS -.xls
CiteHR.AI
(Fact Checked)-The use of symbols in Excel formulas does not affect the calculation. You can sum the professional tax amounts with or without the symbols. (1 Acknowledge point)