Nov 6, 2009 at 01:26 AM
Posts2Registration dateMonday November 9, 2009StatusMemberLast seenNovember 10, 2009
Nov 10, 2009 at 01:03 AM
It is a calculation that I want to do.
I have repayment data which may be monthly, quarterly, halfyearly say B
I have to pick up the data(B) from one sheet arrive at outstanding balances (ie opening- repayments) . and on the balances another calculation will be done.
To do stimulation or analyse the data I may either increase or decrease the amount of repayment.
In that case , my calculation sheet should not pick up repayments once outstanding becomes nil.