Hi all,

cost aggregate dep c/fwd charge for year agg dep b/fwd value
2007
1000 100 50 150
850

I have a spreadsheet set out as above. Is there a way i can create a formula
in the agg dep c/fwd cell that will increase by the charge for the year
without having to manually input figures every year? (instead of just typing
150 in the cell) And that would also work for subsequent years.

i.e. cells to read 1000 150 50 200 800 850
800 being this years value with a further years depreciation charged.