Data tables ? Circular references ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 05 Feb 2008 16:03 GMT

Hi,

If I setup a data table as follows:

A1=0
A2=0
A3=A1+A2

Then in B3 place the formulae A3+1 and copy it along to K3
And in A4 place the formulae A3+1 and copy it down to A13
Finishing off by selecting the range A3:K13 and
choosing Data->Table, Row input cell = A1, Column Input cell = A2
The results in the intersection start from 2 and end at 1.7E+11

Now if I Edit->Copy, PasteValues the formulae in cells B3:K3, and likewise
value the
formulae in A4:A13 the results change twice over, once for each
Copy-PasteValues
sequence.

What's going on ?

Regards

Steve

Reply to this Message

Max - 06 Feb 2008 08:05 GMT

Think the intersection cell in the data table
cannot be the same cell as the intended output

Try the "Data > Table" set-up this way

With the output cell in A3

> A3: =A1+A2

Put in say, B4: =A3 (a simple point to A3)
List the horiz and vertical figs: 1-10 in C4:L4 / B5:B14,
Select B4:L14, click Data > Table,
Point the row/col inputs at: A1/A2 > OK

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi,
>
[quoted text clipped - 21 lines]
>
> Steve

Reply to this Message