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!!