Here we go again.

[scott]

I seem to run into this alot. I'm not really grasping the
formula concept but here goes. Rows 2-5 are entry fields
and I have entered the following values.
A B C D E
1
2Opening Value? 23000
3Annual ROR 6.15%
4Annual Debit 2300
5Annual Deposit 0
B C D E F(NA) G

6 Month Balance ROR Debit Balance
7 1 23000.00 6.15% 2300 21973.05
8 2 21973.05 6.15% 2300 20882.94
9 3 20882.94 6.15% 2300 19725.79
10 4 19725.79 6.15% 2300 18497.48
11 5 18497.48 6.15% 2300 17193.62
12 6 17193.62 6.15% 2300 15809.58
13 7 15809.58 6.15% 2300 14340.42
14 8 14340.42 6.15% 2300 12780.91
15 9 12780.91 6.15% 2300 11125.48
16 10 11125.48 6.15% 2300 9368.25
17 11 9368.25 6.15% 2300 7502.95

My formula in column E is =(C7-E7)+(C7-E7)*D70

The C column i have just as =previous year end balance


Eventually the balance becomes zero. I was wondering how
to make the calculations stop when it zeros out, instead
of having it continue into the negative balances
infinitely. Thanks for any help and patience.

 

[steve]

Scott,

I think you want something like:
=If(C7>E7,(C7-E7)+(C7-E7)*D70,"")

When C7 = E7 or is less than the result will be a blank cell.

 

[Reggie]

Scott, I believe Steve ment
=IIF(C7>E7,(C7-E7)+(C7-E7)*D70,"")
not
=If(C7>E7,(C7-E7)+(C7-E7)*D70,"")

Regards!

 

[steve]

Reggie,

Depends on whether you're working in code or directly in the sheet.
I gave the sheet solution.

 

[Reggie]

That's true. Wasn't thinking about that. Now he knows both methods!

--
Reggie

"Half this game is 90% mental."

----------