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.