balance with three columns one row.

  • Thread starter Thread starter DizzyWench
  • Start date Start date
D

DizzyWench

ok trying to create a budget that opperates like this


Deduction, Start Balance, EndBalance
£10 £800 £790

ok its ok if i want to take £10 from the start balance of £800 i get
£790, Yippeee , yaeh and yahoooo....

but how do i ..... when the deduction cell is changed to another
value, to delete that from the new balance of £790 and not the 800....
please help.... i'ts driving me round the

Deduction, Start Balance, EndBalance
£10 £800 £780

bend...seriously ...it really is......
 
Wench,

You can, but you don't want to. Such cells eat up the transactions, and you
never know what has been entered, and what hasn't. Make a table. Put each
deduction in its own row. Keep a running balance. Manually put the
beginning balance in the "Start" row, then use a formula to keep track of
balances.

Date Deduction Balance
1/1 Start 25.00
1/2 10.00 =C2-B3

When you copy the formula down with the fill handle, you'll get = C3-B4,
which is exactly what you need.
 
yeah i could, but i really want to know how to get around thi
problem...... been at it all day... its a vendetta now... excell wil
not win
 
Back
Top