Formulas

[btr]

I want to learn how to do formulas so that I always get an updated balance
each time I make an entry. Is there an "easy" way to do this for someone is
"computer illiterate"?

Example: Balance: $55,690.00 Column K 5
Less 3,213.54 Column J 6
New Balance Column L7
Less 2,894.75
New Balance

 

[KePaHa]

=KG-J6 ?

 

[Brad]

Typically how data is arranged can dictate how the formulas are built.

If possble consider having deposits in column J, withdrawals in column K and
the balance in column L

J K L
5 20
6 70 30 +L5+J6-K6

entering the above formula in L6 would provide the answer of 60 and then you
simply copy that equation down as desired....

 

[Ron@Buy]

Suggest you modify formula to:
=IF(AND(J6=0,K6=0),"",L5+J6-K6)
to supress the balance from appearing all the way down column L !