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
teju-kuna
formula for professional tax for andhrapradesh sir , details already given above sir,
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.
rupesh-ghadi
=IF(AND(AA$1="Feb PT",X2>10000),300,IF(X2>10000,200,IF(AND(X2>7500,Q 2:Q31>"Male"),175,0)))

AA$1 = WRITE IN CELL FEB PT
X2 = SALARY WAGES
SELECT GENDER ROW

THIS IS MAHARASTRA PT SLAB
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
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)))))
PAGE
1
2
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute