Maybe..

=IF(COUNT(E7:F7)<1,"",G6+F7-E7)
and
=IF(COUNT(E7:F7)<1,"",G6+(F7-E7)*(D7="C"))



Treesy wrote:

Doesn't like the formula. Gives an error. Can't figure out why. The cell
references are correct.

"Roger Govier" wrote:

Hi

Try
=IFCOUNT(E7:F7)<1,"",G6+F7-E7
and
=IFCOUNT(E7:F7)<1,"",G6+(F7-E7)*(D7="C")

--
Regards

Roger Govier


"Treesy" wrote in message
...
Hmmm...this seems to work but I did tweak the formula so it would
subtract E3
from F3. Otherwise, it was giving me a negative number. However, I'd
like
it to not show a running balance down the column if there aren't
transactions
listed in the other columns (A through F). Can you help me add the
"ISBLANK"
function to this formula? Otherwise, it works great! Thank you.

"Elkar" wrote:

For your "Projected" amount (column G) use this formula, starting in
cell G3
and copy down.

=E3-F3+OFFSET(G3,-1,0)

For your "Actual" amount (column H) use this formula, starting in
cell H3
and copy down.

=OFFSET(H3,-1,0)+IF(D3="C",E3-F3,0)

If your amounts start on a different row than 3, then adjust the cell
references accordingly. The use of the OFFSET function will allow
you to
insert and delete rows later as needed without messing up your
formulas.

HTH,
Elkar


"Treesy" wrote:

Hi there. I have my checkbook register in Excel and I'd like to
add a column
that shows "actual balance", based on items that have cleared my
account.
Currently, column G has the following formula to calcuate the
balance:
=IF(AND(ISBLANK(E7),ISBLANK(F7)),"",G6-E7+F7)

When an item clears my account, I put a capital C in column D. Can
the
above formula be altered so that if there is a C in column D, then
it goes
ahead and performs the calculation. If there is no C, it does no
calculation
and simply repeats the value in the cell above?

Ultimately, I'd like to have 2 columns, one would be a projected
balance
(assuming everything clears my account) and one would be an actual
balance
(to compare against the balance showing on my checking account).
If anyone
can think of a different way to accomplish this, I'm open to ideas.
:)

Thanks for your help!!




--

Dave Peterson