How to do calculations and arrive at balances

Closed
lisa - Nov 6, 2009 at 01:26 AM
donjeck Posts 2 Registration date Monday November 9, 2009 Status Member Last seen November 10, 2009 - Nov 10, 2009 at 01:03 AM
Hello,
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.

1 reply

donjeck Posts 2 Registration date Monday November 9, 2009 Status Member Last seen November 10, 2009
Nov 10, 2009 at 01:03 AM
* and shift then = and scroll down
0