Formulas
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....
--
Wag more, bark less
"btr" wrote:
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
|