View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Formula Question

In your very 1st Row you could enter your debits and credits and this formula
in column F: =E2-D2 (assuming your data starts in row two due to headings.)

Then in the next cell down in column F put this formula: =F2+E3-D3
Then copy this formula down as needed in column F. It should look at your
previous balance (in F) then add the credit and subtract the debit to create
a new balance.

"dramajuana" wrote:

Okay, I don't really know how to word this, so I'm sorry if it sounds awkward.

I'm trying to set up Excel so that it can basically be my checkbook registry
so that I don't mess up the math. So, I have a column for debits (D), one for
credits (E) and one for the running balance (F).

Is there a forumla that I can apply to column F that will see what's in D
and E for that row, add or subtract what's there, and then apply that to the
previous row's F? Or do I just have to do separate forumlas for each row...?