Pf Calculation Formula In Excel
Advance Search Feature
Available Downloads - Page 1
Search Result For "Pf Calculation Formula In Excel" - 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
I need to put a formula in an Excel sheet to calculate PF amount.So, how do we put a formula if the wage ceiling is less than 15000 (standard deduction) or greater than 15000\. Can somebody help me with an Excel formula, please…
Dear Sir,One of my friends is working as a security guard. He is paid on a daily basis. The security agent deducts PF from his salary. Please tell me how he will calculate PF against his salary.
Salary Slip Headwise Detail RulesPlease find below the rules for details mentioned in the salary slip:1\. Basic Salary2\. Allowances3\. Deductions4\. Gross Salary5\. Net SalaryThese are the key components that are typically included in a salary slip. Each sectio...
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...
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")))