RE: how do I...?

[Phillip Shelton <shelton usq edu au>]

This requires careful use of the $ to enforce absolute addressing.

if the cell columns for your example are A B C D and the rows are 1 2 3 4
then for the examble that you give the formula put into cell B1 is 

$A1+B$4

Then if you fill down and across this will give you the table in the
example.

Phill

-----Original Message-----
From: Isaac Kriegman [mailto:zac ozacua org]
Sent: Sunday, 28 April 2002 12:01 PM
To: gnumeric-list gnome org
Subject: how do I...?


I have a spread sheet with where I often change cells A1 and B1 in order 
to see how they effect cell C1.

I would like to generate a table which along the x-axis runs through a 
range of A1 values and the y-axis through B1 values.  The table data 
itself would be the C1 result.

So for instance if C1=A1+B1 how would I generate the following table data:


            1  |  2    3    4

(B1 values) 2  |  3    4    5    <--- resultant C1 values

            3  |  4    5    6
                ______________

                 1    2    3
                (A1 values)


Note: though my example is quite simple, and I could easy create a 
fomula for it, my real spread sheet is much more complex, so creating a 
custom formula would be more difficult.

Is there a simple way to do this?

Thanks,
Zac

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list