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

teju-kuna

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
27th December 2018 From India

teju-kuna

formula for professional tax for andhrapradesh sir , details already given above sir,
27th December 2018 From India

abhaygaikwad93@gmail.com

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.
9th July 2021 From India, Mumbai

rupesh-ghadi

=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
2nd November 2023 From India, Mumbai

rupesh-ghadi

=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
2nd November 2023 From India, Mumbai

travel-time4770339

@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)))))
2nd November 2023 From India, Gurgaon

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.