Recalculate formula using incremental changes

[krokodilizm]

I'd really google this if I knew how to phrase it properly but it keeps coming up with irrelevant results. Here is my problem:

A1=25,000
A2= a complex chain of formulas that depend on the entries in A1

I'd like to list all A2 results in the range D1:D16 subject to the values in C1:C16.

[TABLE="width: 128"]
<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]C1
[/TD]
[TD="width: 64, align: right"]25000
[/TD]
[/TR]
[TR]
[TD="class: xl64"]C2[/TD]
[TD="align: right"]26000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C3[/TD]
[TD="align: right"]27000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C4[/TD]
[TD="align: right"]28000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C5[/TD]
[TD="align: right"]29000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C6[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C7[/TD]
[TD="align: right"]31000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C8[/TD]
[TD="align: right"]32000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C9[/TD]
[TD="align: right"]33000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C10[/TD]
[TD="align: right"]34000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C11[/TD]
[TD="align: right"]35000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C12[/TD]
[TD="align: right"]36000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C13[/TD]
[TD="align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C14[/TD]
[TD="align: right"]38000
[/TD]
[/TR]
[TR]
[TD="class: xl64"]C15[/TD]
[TD="align: right"]39000[/TD]
[/TR]
[TR]
[TD="class: xl64"]C16[/TD]
[TD="align: right"]40000[/TD]
[/TR]
</tbody>[/TABLE]

Any solutions based on a formula or VBA will be welcome.

Thanks

 

[krokodilizm]

Geez, it's done using the Data Table function. I knew that I knew this!
Thanks anyone reading this...