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
[email protected]
 
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
[email protected]
Click to expand...

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

I think this will work for you.
 
Top