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
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
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
From India, Mumbai
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.
Professional tax hyderabad.doc
Professional Tax.zip
Professional Tax 01-Apr-2009.pdf