Using Excel to do additions and subtractions

C

Charlie Donohue

I was trying to make a bank form that would keep a running balance for me.
I would have three money columns
Column A Column B Column C
A = deposits B = withdrawals and C = Running Balance.

Any help would be most appreciated

Thanks Charlie
(e-mail address removed)
 
H

Harvey Waxman

Charlie Donohue said:
I was trying to make a bank form that would keep a running balance for me.
I would have three money columns
Column A Column B Column C
A = deposits B = withdrawals and C = Running Balance.

Any help would be most appreciated

Thanks Charlie
(e-mail address removed)

Starting balance in C1
In C2, IF(AND(A2="",B2=""),"",C1+A2-B2)
Copy down.

I think this will work for you.
 

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