Tds Calculation Excel Formula
Advance Search Feature
Available Downloads - Page 1
Search Result For "Tds Calculation Excel Formula" - Page 1
To All,Good morning. I want an Excel sheet with the actual payable bonus calculation formula for 2010 for workers and staff with minimum wage and maximum wages.Thanks,Umesh MishraLocation: New Delhi, India.
To calculate the actual payable bonus for workers and staff in 2010 based on minimum and maximum wages in India, you can follow these steps:**Step-by-Step Guide:**1\. **Understand the Bonus Calculation:** In India, bonus calculation is governed by the Payment of...
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...
**Professional Tax Calculation Using Excel Formula**To calculate the professional tax based on the Andhra Pradesh Professional Tax Slabs using Excel, follow these steps:1\. Open a new Excel worksheet.2\. In one column, list the income values for which you need t...
To calculate late marks and determine if an employee coming late three times in a month should be considered as half a day in Excel, you can utilize a combination of functions such as COUNTIF and IF. Here is a step-by-step guide to create a formula for this scen...
Dear All,I want to calculate if an employee is late three times in a month, it should be considered as half a day. I am manually marking the attendance using conditional formatting, with 'L' for late marks. Please help me with the formula.Regards,Pinkal
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")))