Excel Formula For UAE Gratuity Calculation For Bulk Employees
Advance Search Feature
Available Downloads - Page 1
Search Result For "Excel Formula For UAE Gratuity Calculation For Bulk Employees" - Page 1
Sure, I can help you with that! Please send me the scanned assignment so that I can understand exactly what you need. You are looking for formulas for DA, TA, HRA, Spl. Allow, EPF, HRD, and Tax. I will assist you in explaining the Excel assignment to the student...
Hi dear Chandrakanth,I forgot to mention about the wage limit. If the wages are less than 6500, then the formula will be calculated as (basic + da) * 12%. If it is greater than 6500, it will be fixed at 780\. Apart from that, the employer provident fund will be ...
Kindly send me the Excel file containing formulas for the calculation of EPF, etc.
Thanks for the calculations. Can you please help me to know the Excel formulas to generate the 3A/6A reports through the said sheet.Regards,Kumar9885576600
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...
Can anyone send me a format in Excel for gratuity calculation as per U.A.E with IF conditions? The rule is as follows:1st year: 7 days' salary of basic2nd year: 14 days' basic salary3rd year: 21 days' basic salary3rd to 5 years: 21 days' basic salary x number of...
Hi Chief,Any luck? I'm looking for the same, and I hope someone can help me out with a Gratuity Calculator.Regards,Mark
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