I am a little rusty and need your help.

I have created a spreadsheet to calculate various amount of IRA contributions for several employees.

In Field #1, I enter the total amount contributed by the employee (manual entry).

In Field #2 - 4, a formula calculates the amount to be deposited into each fund they chose for their retirement account. (These formulas work fine, and I even selected precise calculation to ensure they are accurate).

PROBLEM:

In some cases, my three dollar amounts (accurately calculated) don't equal the originally manual entered number in Field #1.

Employee Fund Allocation EE Contrib ER Contrib

John Doe $151.51 $90.90

155 30% $45.45 $27.27
183 40% $60.60 $36.36
201 30% $45.45 $27.27


The formula to calculate the percentage of $151.51 and $90.90 works fine and round up precisely. BUT, the total sum of all three amounts do not EQUAL the manually entered figure each time. In this case, the sum of the three amounts only equal $151.50.

How can I get my formula to ensure that not only does it calculate the correct percentage, but ensure it also equals the amount I entered (how can I get it to add a penny to any one of the dollar amounts).

I am stumped.
I can't attach my full excel document because it contains sensitive employee information.

Any help will be appreciated.