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
From India
teju-kuna
formula for professional tax for andhrapradesh sir , details already given above sir,
From India
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
=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
=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
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)))))
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.