Originally Posted by Lowan Chan

Hi,

Can anyone help me to make a formula which can automatically calculate a
retire fund:

a staff join company on April 20, 2010, salary $15,000, I need to calculate
his retire fund on the third month, which is June 30. So on June 30, the
total retire fund on June 30 that company needs to pay should be: 275+750+750
April: 15,000/30*11days*5%=275
May: 15000*5%=750
Jun: 15000*5%=750
but July 31 onward, it will back to normal salary * 5%
assume that the salary paid in April - July is in cell A1, B1,C1, D1, and
retire fund for each month is in cell A2, B2, C2, D2.

thanks a lot!
--
Lowan