Hi,

I have a sheet with an amount to input, and the amount will be divided by the # of account the member has. However, if it falls into example, 2000$ for 3 accounts, it will be 666.67$ x 3 = 2001$. I will need something a macro or formula to auto adjust that if the total is 2001$, it will add or minus 1 or 2 of the 3 accounts by 1 or 2 penny. 666.67, 666.67 and 666.66 (this scenario). If the total is 1000$, it will be 333.33, 333.33, 333.33, so it 999.99$ which is missing 1 penny, then it will add 1 penny to any of the 3 accounts. But some member has 9 accounts, so the # of account will varies.. Is there a way to do that to add the balance to the first account.??

Here is an example of the 2 possibilities spreadsheet with formula that I am using.

TEST.xlsm