On Sat, 2008-10-04 at 18:47 +0200, Jean Bréfort wrote: > Le vendredi 03 octobre 2008 à 12:43 +0000, Robert Paul Bywater a écrit : > > > > I am a novice at Gnumeric so I need help. > > > > I have an array in a Gnumeric sheet, let's call it B1:K50. > > > > I want to do numeric operations on *all* the elements in this array. > > > > Firstly, I highlight the array. (But one cell seems to still be more > > 'active' than the others, > > it is white while the others are blue. It is usually B1. Why is that? > > I want my formula applied > > to *all* the cells. How do I ensure this?). > > The destination cells should not be the same as the cells containing > your original data, or you'll end with cyclic dependencies which might > not give anything significant. > > > > > One kind of operation I want to do is like this: > > =product((a-B1:K50)*(b-B1:K50)) > > where a,b are constants and are integers as are the elements in > > B1:K50. > > I don't undestand your formula. Anyway, the product function does not > accept that kind or argument.
Well, it does. On the otehr hand it calculates the product of a large number of terms each being the product of 2 differences. I doubt you really mean that. Andreas -- "Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own." Rousseau Andreas J. Guelzow Pyrenean Shepherds _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list