Hi all, I am sharing an Excel Add-In to determine the Professional Tax in various states. Use the formula as provided below: | Sr No | State | Amount on Which Prof Tax | Prof Tax | Formula Used | |-------|--------------|---------------------------|----------|------------------| | 1 | MP | 15000 | 125 | =ptmp(D4) | 2 | West Bengal | 12000 | 110 | =ptwb(D5) | 3 | Orissa | 18000 | 150 | =ptorissa(D6) | 4 | Maharashtra | 25000 | 200 | =ptmaha(D7) | State: Formula: Remark: - West Bengal =PTWB(Cell Ref) - Tamil Nadu (Half Yearly) =PTTAMILNADU(Cell Ref) - Orissa =PTORRISA(Cell Ref) - Maharashtra =PTMAHA(Cell Ref) Please verify slab for February - Kerala (Half Yearly) =PTKERALA(Cell Ref) - Madhya Pradesh =PTMP(Cell Ref) Please verify slab for February - Karnataka =PTKARN(Cell Ref) - Gujarat =PTGUJ(Cell Ref) - Assam =PTASSAM(Cell Ref) - Andhra Pradesh =PTANDHRA(Cell Ref) Thanks and regards, Anvesh
1 Attachment(s) [Login To View]