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.

Scott,

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

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

--
sb
"scott" wrote in message
...
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.

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

Regards!
-----Original Message-----
Scott,

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

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

--
sb
"scott" wrote in
message
...
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.



.

Reggie,

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

--
sb
"Reggie" wrote in message
...
Scott, I believe Steve ment
=IIF(C7E7,(C7-E7)+(C7-E7)*D70,"")
not
=If(C7E7,(C7-E7)+(C7-E7)*D70,"")

Regards!
-----Original Message-----
Scott,

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

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

--
sb
"scott" wrote in
message
...
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.



.

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

--
Reggie

"Half this game is 90% mental."

----------
"steve" wrote in message
...
Reggie,

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

--
sb
"Reggie" wrote in message
...
Scott, I believe Steve ment
=IIF(C7E7,(C7-E7)+(C7-E7)*D70,"")
not
=If(C7E7,(C7-E7)+(C7-E7)*D70,"")

Regards!
-----Original Message-----
Scott,

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

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

--
sb
"scott" wrote in
message
...
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.



.