Formulas
 

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

Formulas
 

=KG-J6 ?

"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

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

Formulas
 

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 !

"Brad" wrote:

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