Le mercredi 07 novembre 2012 à 02:18 -0800, Mike Simms a écrit :
> Hi Jean,
>
> OK, we're getting somewhere now, I have a created the columns C and D as you
> say, and I've typed in
> =linest(a1:a100;b1:d100,TRUE)
> and pressed Ctrl+Shift+Enter and the indices {1,1}[0,0] appear. Lo and
> behold the value is the coefficent of the x^3 term which I confirm by making
> a chart of the data and adding a trendline and equation.
>
> But when I add the same linest expression into the next cells in the row,
> the same indices appear and the same value appears, when they should be
> changing, no?. I am pressing Ctrl+Shift+Enter each time. What have I missed?
>
You need to select the four cells, enter the formula and Ctrl+Shift
+Enter to fill them at once. If you enter the same formula to each cell
in order, you always get the first cell.
Regards,
Jean
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
