Save Rs 499 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

Professional Tax Excel Formula | Excel Worksheet Utility

14968 views

Save Share

Babita Jain

Personal Assistant

318 Points Posted on 27 September 2021

We found the excellent Excel worksheet formula which you can use to calculate Professional Tax very easily and quickly. Download the attached file.

Attached File : 1751432 20210927123510 professionaltaxformula.xls downloaded: 737 times

Replies (4)

Quick Summary

This discussion shares a useful Excel formula designed to simplify the calculation of Professional Tax. The original poster has provided a downloadable file containing the formula, which they have successfully implemented themselves. Other users have expressed interest and requested formulas applicable to all 21 states where Professional Tax is levied.

Babita Jain

Personal Assistant

318 Points Posted on 28 September 2021

See attached file. Last post I forgot to add file. Download the attached professional tax formula file.

Aashok Kumar Sharma

Finance/Compliance Consultant

69275 Points Posted on 28 September 2021

I have used the same formula in my sheet as well.

Thanks

Supriya Das

2 Points Posted on 18 April 2023

Thanks for sharing the valuable information but it is related to particular state. So, I request you to share the formula for all 21 state wherein PT is applicable.