How Do I Calculate Professional Tax in Excel for Different Income Brackets?

manjutejaswi83@ovi.com

Dear all,

Professional Tax Calculation in Excel

Now, P.Tax is Rs. 1 to 9,999 is zero, 10,000 to 14,999 is Rs. 150, and 15,000 and above is Rs. 200. How can I calculate this in an Excel sheet?

Regards

antony-fernando

Enclosed is the PT Slab along with the formulas in Excel. Thank you.

1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute