how do I...?

[Isaac Kriegman <zac ozacua org>]

I think I did a poor job explaining the problem I was trying to tackle. 
Imagine I have a large and complicated spread sheet.  The whole spread 
sheet exists to calculate a single number, in cell C23.  Most of the 
changes I make, for different scenarios, are to cells B1, and B2.  I'm 
trying to figure out how to automatically generate a table that looks 
like this (slightly different from my last email):

           1  |  2    3    4

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

           3  |  4    5    6
                ______________

                1    2    3
                (B2 values)



Thanks for your help,
Zac

Phillip Shelton wrote:


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