| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of constant decrement
w/o using SUMPRODUCT and using formula for sum of arithmetic
progression you might use the following: A1=100000 A2=1500 A3=15 A4=12 (or number of months generally) =A4*(2*(A1-A2)-(A4-1)*A3)/2 HIH On 7 Maj, 07:56, 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. |
| 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 | |||
![Jarek Kujawa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
