Data tables ? Circular references ?

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

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
 
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
Click to expand...

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

---
 
Back
Top