Hi,
I am working on salary calculations in Excel and facing an issue regarding PF calculation. We have set our basic salary at 6500 for 30 days for employees whose salary exceeds 6500. I have applied the PF calculation formula accordingly. However, in cases where an employee's salary is less than 6500 and they have worked only 15 days in the current month, I am unsure about the formula to use in this situation.
Regards,
Dilip
From India, Pune
Acknowledge(0)
Amend(0)
7I am working on salary calculations in Excel and facing an issue regarding PF calculation. We have set our basic salary at 6500 for 30 days for employees whose salary exceeds 6500. I have applied the PF calculation formula accordingly. However, in cases where an employee's salary is less than 6500 and they have worked only 15 days in the current month, I am unsure about the formula to use in this situation.
Regards,
Dilip
From India, Pune
Acknowledge(0)Amend(0)
Dear Dilip You can use IF and then functio of EXcel for this problem. Regards Alpna Prasad
From India, Allahabad
Acknowledge(0)Amend(0)
From India, Allahabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY EXCEL.zip
Excel Formulas.xls
Excel Formulas.ppt