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.

C1	25000
C2	26000
C3	27000
C4	28000
C5	29000
C6	30000
C7	31000
C8	32000
C9	33000
C10	34000
C11	35000
C12	36000
C13	37000
C14	38000
C15	39000
C16	40000

<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

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...