For the payout of credits of multiple people over time, i wanted to setup a table where the “Available Payout Amount” is divided through the “Current Number Of People”. So everybody gets the same, unless its the last installment of a person and the amount is lower than the Divided Payout Amount. That’s where i’d need to use the difference of unused amounts for last installments and distribute it to the others again.

How is that being done ? I manually calculated the values in the following screenshot. A sample .xls for Excel 2003 would be very cool.

2014_01_06_23_26_10.jpg

Regards,
Frank