Thread: Formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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