Advance Search Feature
Available Downloads - Page 1
Search Result For "Tax Calculation In Excel" - Page 1
I want a tax calculation formula calculator in Excel. Please help me. If I enter the total yearly income and savings, I can get the tax amount in seconds. Help me prepare a tax calculator.VishalGujarat
Hi Vishal,Please use this…...Regards,Kapil Kotwal
Dear Seniors,Good morning.The profession tax slab in Maharashtra is as follows:- Above Rs 10,000, the profession tax is Rs 200- Above Rs 5,000, it is Rs 175I need assistance with the generation of the amount in the profession tax column based on the salary amoun...
Good Morning!Your question pertains to the calculation of professional tax (P.T.) based on salary slabs in Maharashtra, specifically for those earning above Rs 5000/- and Rs 10000/-.Here's a simple way to calculate it:1\. 💰 If an employee's monthly salary is ab...
Dear All,I am mentioning below the Andhra Pradesh Professional Tax Slabs. Based on this, I need the Professional Tax calculation with an Excel formula. Please assist me.AP Professional Tax Slabs:- Income Between Rs. 0-5000: Professional Tax is Rs. 0- Income Betw...
Dear All,I prepared an "INCOME-TAX CALCULATOR" in Excel format yesterday. Please download it if you need. Your feedback and suggestions are welcome.Regards,Vinay Gupta
Hi,Find enclosed calculation for PT. This is a simple format as you need. Just enter the number of employees in a particular slab and the total will come at the end.If you need the same calculations in the Salary Statement, then you should use multiple If condit...
How to calculate professional tax in Excel format.In West Bengal, the professional tax rates are as follows:1-3000: 0, 3000-5000: 30, 5000-6000: 40, 6000-7000: 45, 7000-8000: 50, 8000-9000: 90, 9000-15000: 110, 15000-25000: 130, 25000-40000: 150, 4000 and above:...
To calculate the Professional Tax slab in Gujarat using the IF function formula in Excel, you can use the following formula:=IF(C2>12000,"₹200",IF(C2>9000,"₹150",IF(C2>6000,"₹80",IF(C2>3000,"₹0","₹0"))))Where C2 represents the gross salary.The tax slab for calcu...
=IF(C2>=12000, "200", IF(C2>=9000, "150", IF(C2>=6000, "80", "0")))