Hi there, I'm trying to construst a form in excel.
The purpose is to distribute available income between creditors on a pro rata basis. I have created the form with spaces for 25 creditors. I am using the calculation Individual debt ÷ by total debt x available income = pro rata payment. This works fine. I now want to take it a stage further. If i change a pro rata payment by inserting a manual payment (say the calculation was less than £1.00 and i wanted it to be £1) how do i get the remaining cells to recalculate to maintain the original value of the available income.
I would be grateful if anyone could help me
Thank you
Jane
The purpose is to distribute available income between creditors on a pro rata basis. I have created the form with spaces for 25 creditors. I am using the calculation Individual debt ÷ by total debt x available income = pro rata payment. This works fine. I now want to take it a stage further. If i change a pro rata payment by inserting a manual payment (say the calculation was less than £1.00 and i wanted it to be £1) how do i get the remaining cells to recalculate to maintain the original value of the available income.
I would be grateful if anyone could help me
Thank you
Jane