"Abdul" wrote in message
...



I have thefollowing
Y1 Y2 Y3 Y4
1000 1000 1000 1000
800 800 800
640 640
512
Total 1000 1800 2440 2952

the logic like this

Every year 1000 New Plus 80 % from previous year diminishing value

so Y3 figures are like this

1000 New
80 % of Y2 New =800
80 % of Y1 remaining (800)=640

Can I get this one through a formula

thanks

A B C D E
1 YEAR Y1 Y2 Y3 Y4
2 NEW 1000 1000 1000 1000
3 TOTAL 1000 1800 2440 2952

The Formula is quite easy and can be done in many ways.

With this one, NEW is the value you wish to add each year, and TOTAL is the
calculated new value.

Cell B3: =b2
Cell C3: =((B3/100)*80)+C2

Drag the Formula into Cells D3 and E3