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)
1From India, Mumbai
Acknowledge(0)Amend(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.
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)