Struggling with PF Calculation for Part-Time Salaries in Excel – Any Advice?

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

Dear Dilip,

You can use the IF and THEN functions of Excel for this problem.

Regards,
Alpna Prasad

You can put a formula like:

=IF(OR(basic salary<6500, days<30), 0, basic salary*12%)

Here, basic salary and days refer to cells containing salary and present days.

Hope this will solve your problem.

Subject: Review of Attachment

Mr. Dilip,

Please check this attachment. I hope that it is useful.

U. Muninder