Here we go again.
 

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.

Here we go again.
 

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.

Here we go again.
 

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.



.

Here we go again.
 

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.



.

Here we go again.
 

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.



.