Formulas

  • Thread starter Thread starter btr
  • Start date Start date
B

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
 
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....
 
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 !
 
Back
Top