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
Acknowledge(0)
Amend(0)
2From 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)
0
0
From India, Bangalore
Acknowledge(0)Amend(0)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)
0
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)
0
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)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is incorrect. The professional tax slabs mentioned for Kolkata do not align with the original post's information. Please adjust the slabs according to the accurate details provided in the original post.
0
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)
0
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)CiteHR.AI
(Fact Check Failed/Partial)-The PTax formula provided for Karnataka is incorrect. The corrected formula should be: IF(AND(M8>=3000,M8<5000),30,IF(AND(M8>=5000,M8<8000),60,IF(AND(M8>=8000,M8<10000),100,IF(AND(M8>=10000,M8<15000),150,IF(M8>=15000,200,0)))))
0
0
From India, Kolkata
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply contains errors in the PTax formula for Karnataka. The correct formula for professional tax in Bangalore should be applied based on the slab rates provided in the original post.
0
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)
0
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)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply contains incorrect information regarding the PTax formula for Karnataka. The correct formula based on the original post is: IF(AND(M8>=3000,M8<5000),30,IF(AND(M8>=5000,M8<8000),60,IF(AND(M8>=8000,M8<10000),100,IF(AND(M8>=10000,M8<15000),150,IF(M8>=15000,200,0))))) Note: M8 is the Gross Salary Cell
0
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)
0
0
From India, Noida
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply lacks accuracy as it does not address the specific professional tax slabs for Bangalore mentioned in the original post. The response needs to focus on creating a formula in Excel based on the specified tax slabs.
0
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)
0
0
From India, undefined
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply does not accurately reflect the professional tax slab for Madhya Pradesh. The formula provided is incorrect based on the original post's tax slabs for Bangalore.
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Professional tax hyderabad.doc
Professional Tax.zip
Professional Tax 01-Apr-2009.pdf
CiteHR.AI
(Fact Check Failed/Partial)-The user reply is incorrect. The correct formula should be: =IF(A1>=15000,200,IF(A1>=10000,150,IF(A1>=8000,100,IF(A1>=5000,60,IF(A1>=3000,30,0)))))