Help with setting a formula

H

HankL

I am attempting to setup two columns. One column is adding charges. The
other is showing the charges deducted from a starting balance. I am trying
to keep track of a cash card as I am spending the funds.
 
G

Gary''s Student

Put your initial balance in A1 and nothing in B1
In A2 enter:

=A1-B2 and copy down

As you enter charges in B2 and going down, they will be debitted in column A
and the balance will appear.
 

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

Similar Threads

Cumulative formula for word table 0
Percent Help 2
Creating a summary page without blank lines 1
Setting column width in a table with a macro is not working 0
Problem with SET & REF function 0
Adding a Formula as a data variable in a pivot 5
Two columns followed by single page-width column on same page 0
Check register with running balance 0

Top