How do i set up a budget with self totalling column
Hi
Try entering in Cell D2, whatever is the opening balance for the account
(could be 0)
Then in cell D3 enter
=IF(COUNT(B3:C3)0,)*B3-C3+D2
Copy down as far as required
--
Regards
Roger Govier
"finaleternity" wrote in
message ...
I have made a basic budget with columns
Date, Money in, Money out, Balance
what I want to know is if there is a way for me to put a formula in
the
Balance column which will recognise if there is a number in the in r
out
column and if it is in the IN to add it to te previous balance and if
it is
in the OUT to minus it from the previus balance
Thanks I hope someone can help
Kristie
|