Excel Conditional Pro rata calculation in excel

Joined
Jun 5, 2009
Messages
1
Reaction score
0
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
 
Back
Top