Declining a balance until it reach zero

Hi

I'm looking for an excel formula to reduce a balance equally over a 12 month period and at the 13 month the balance should be zero.

For example:

Cell (B2) i have 12,000.
In Cell (C2:N2) i want 1,000 in each cell which will equal 12,000 over 12 months.
When the formula is extended to Cell (O2) it would show that a zero balance is remaining.

.......... Jan......Feb .....Dec Jan13
12,000 1,000 1,000 1,000 0


Thank you,

Andrew.

Andrew,

Attached is an example workbook based on the criteria you described.
In cell B2 is the Starting Balance of $12,000.00
In cell C2 and copied right is this formula:

Please Login or Register  to view this content.

Same formula, slightly different syntax:

Please Login or Register  to view this content.