Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to get number + 80% from previous
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to get number + 80% from previous
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to get number + 80% from previous
see reply to your posting in another group
-- Regards Roger Govier "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding one to the number from the previous cell with text... | Excel Discussion (Misc queries) | |||
formula to get number + 80 % from Previous Balance | Excel Worksheet Functions | |||
previous number not changing | Excel Worksheet Functions | |||
sum previous x number of cells | Excel Discussion (Misc queries) | |||
Sum of previous offset number of cells not to exceed certain value | Excel Worksheet Functions |