How do I create a running balance?

K

Kate

I am finding it extremely diffucult to have a running balance, G column is
the running total, anything in E column is to be subtracted from G column and
anything in F column is to be added to the G column total.
So G-E+F=G
Does this make sense and how in blazers do you write the formula so it does?
I am tearin my hair out!!!!
Thanks
 
T

Tom Hutchins

I assume your running total is running down the column (G). So, you need to
start with the previous value of G (from the row above), subtract E, and add
F to get the new total. In G6 (for example), your formula might be:

=G5-E6+F6

You can copy this formula down column G to keep a running total.

Hope this helps,

Hutch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top