| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to get number + 80 % from Previous Balance
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 | |||
| Running balance from previous sheet | 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 | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
![Abdul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
