| 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 |
| 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 | |||
![Abdul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
