balance with three columns one row.

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......
 
E

Earl Kiosterud

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.
 
D

DizzyWench

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
 
Top