| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of constant decrement
Hi. If I am not mistaken,
= 19170 - 2160*yr where yr is 1, 2, or 3...etc Returns: {17010, 14850, 12690...} = = = = HTH Dana DeLouis JV wrote: Hello, Is there a formula which could answer the following? Monthly deduction is $1,500 in January of 2009 and drops by $15 per month. What are the totals for 2009, 2010 and 2011? Thanks in advance for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do decrement a value in excel | Excel Discussion (Misc queries) | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| How can I automatically decrement a column in hexadecimal numbers | Excel Discussion (Misc queries) | |||
| How do I increment or decrement values in a column? | New Users to Excel | |||
![Dana DeLouis[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
