No Tags Found!


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
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: zip PROF TAX.zip (8.6 KB, 257 views)

Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.