Provident fund calculation for salary computation

**jvlkerala** · 02-05-2010, 04:56 AM

Hi,

I am preapring a salary computation programme for my company. Now I am facing problem to calculate automatically CPF contribution payable and recoverable according to salary. I am looking for a VB programme or relevant formula to solve.

Please find attached file and advice me how to solve this calculation.

Thanks
jvlkerala

**karan** · 02-05-2010, 08:17 AM

I saw your attachments but that didn't help a lot. Can you elaborate a little more on your requirement?

Regards,
Karan

**jvlkerala** · 02-08-2010, 01:29 AM

Hi Karan,

Thanks you for your reply.

Let me enablorate my requirement.

1. Calculate CPF contribution automatically according to salary and age group.
In the Attached File "CPF Calculation >My Requirement and Idea
I have just sorted the calculation formula according to the insturction given by our CPF board (See next sheet "CPF Calculation Guidelines")
We have to contribute CPF 6 different age group range.
Payable means - Total contribution to CPF Board
Recoverable means - to be deducted from Employee.

A new formula suggested by DonkeyOt for 35 years & below is

=IF(B20<35,IF(D20<500,ROUND(D20*14.5%,0),IF(D20<750,D20*14.5%+ROUNDUP((D20-500)*0.48,0),IF(D20<1200,D20*14.5%+ROUNDUP((D20-750)*0.24,0)+120,IF(D20<1500,D20*14.5%+ROUNDUP((D20-750)*0.24,0)+120,ROUNDUP(D13*34.5%,1))))),"")

This should be ok for me but I also want to get the above result for all other age group.

Hope you may understand my requirement, if so please help me or advice whether there is any other VB code for this.

Thank you for your patience and kind help.

Regards
Jvlkerals

**kashemdsh** · 06-25-2018, 03:11 AM

I want to Provident fund laser sheet but not create.

**FDibbins** · 06-25-2018, 11:13 AM

kashemdsh welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.