Hi All,
I am Sending You Excel Add In to find out Prof Tax of Below Mention State.
Use Formula as mention
Sr NoStateAmount on Which Prof TaxProf TaxFormula Use1MP15000125 =ptmp(D4)2West Bengal12000110 =ptwb(D5)3Orrisa18000150 =ptorrisa(D6)4Maharashtra25000200 =ptmaha(D7)
State
Formula
Remark
West Bengal
=PTWB( Cell Ref)
Tamil Nadu (Half Yrl)
=PTTAMILNADU(Cell Ref)
Orrisa
=PTORRISA(Cell Ref)
Maharashtra
=PTMAHA(Cell Ref)
Please check Slab For February
Kerala (Half Yrl)
=PTKERALA(Cell Ref)
Madhya Pradesh
=PTMP(Cell Ref)
Please check Slab For February
Karnataka
=PTKARN(Cell Ref)
Gujrat
=PTGUJ(Cell Ref)
Assam
=PTASSAM(Cell Ref)
Andhara Pradesh
=PTANDHRA(Cell Ref)
Thanks and Regards
Anvesh
From India, Mumbai
I am Sending You Excel Add In to find out Prof Tax of Below Mention State.
Use Formula as mention
Sr NoStateAmount on Which Prof TaxProf TaxFormula Use1MP15000125 =ptmp(D4)2West Bengal12000110 =ptwb(D5)3Orrisa18000150 =ptorrisa(D6)4Maharashtra25000200 =ptmaha(D7)
State
Formula
Remark
West Bengal
=PTWB( Cell Ref)
Tamil Nadu (Half Yrl)
=PTTAMILNADU(Cell Ref)
Orrisa
=PTORRISA(Cell Ref)
Maharashtra
=PTMAHA(Cell Ref)
Please check Slab For February
Kerala (Half Yrl)
=PTKERALA(Cell Ref)
Madhya Pradesh
=PTMP(Cell Ref)
Please check Slab For February
Karnataka
=PTKARN(Cell Ref)
Gujrat
=PTGUJ(Cell Ref)
Assam
=PTASSAM(Cell Ref)
Andhara Pradesh
=PTANDHRA(Cell Ref)
Thanks and Regards
Anvesh
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.