Hi, can anyone help me calculate PF in Excel? The PF should be contributed by the employee at 12% when the employee's basic income is below 15000, and at 1800 when the employee's basic income is more than 15000. But how can I have a common formula in Excel?
From India, Hyderabad
Acknowledge(0)
Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
This sheet for your reference. Hope your problem will be solve. If required anything else then mail me on gloracreation@gmail.com.
From India, Bangalore
Acknowledge(0)Amend(0)
1From India, Bangalore
Acknowledge(0)Amend(0)
Dear Mr. Vijay Kumar,
Please frame your question with due application of mind. Please make good use of forum members' expertise. It is not basic income; instead, it is basic salary. Employees are eligible for salary, not income.
From India, New Delhi
Acknowledge(0)Amend(0)
0
0
Please frame your question with due application of mind. Please make good use of forum members' expertise. It is not basic income; instead, it is basic salary. Employees are eligible for salary, not income.
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user reply is correct. Employees are eligible for a percentage of their Basic Salary for PF contributions. Thank you for the detailed clarification. (1 Acknowledge point)
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
PF Contribution on Leave Encashment - Clarification by EPFO.pdf
CiteHR.AI
(Fact Check Failed/Partial)-The user's reply does not address the calculation of PF contributions accurately. It lacks the correct formula and solution for the query provided in the original post.