Re: multiplication of matrices

• From: Andreas Guelzow <aguelzow pyrshep ca>
• To: Frederic Parrenin <parrenin gmail com>
• Cc: "gnumeric-list gnome org" <gnumeric-list gnome org>
• Subject: Re: multiplication of matrices
• Date: Wed, 17 Aug 2011 16:04:04 -0600

 =ifna(if(isblank(a1:b2),na(),a1:b2)*d1:e2,"")Should workAndreas A J GuelzowOn 2011-08-17, at 13:54, Frederic Parrenin wrote:Actually my title is confusing.I would like to do a cell by cell multiplication of matrices (simple '*' operator).So to simplify, is there a multiplication operator which gives blank when one of the two operand is blank? Best,Frédéric2011/8/17 Andreas Guelzow On Wed, 2011-08-17 at 18:29 +0200, Frederic Parrenin wrote: > I would like to multiply two matrices in Gnumeric. > The first one has cells without any content. > The second one has all its cells with content. > > > When I do the multiplication, the cells without content are used as if > '0' was placed in these cells. > That is, the multiplication of a cell without content with a cell with > content is '0'. > But in this case I would like the resulting cell to not have any > content. > > > Do you know of a way to circumwent this problem? Assuming the blank is in the first row of the first matrix, matrix multiplication will use this entry to calculate each entry in the first row of the result, so you want all of those entries to be blank? In other words if you have to 10 by 10 matrices and one entry of each row of the first matrix is blank do you really want the resulting matrix to be completely blank? If that is the case you cannot use the MMULT function but need to define your own operation. Andreas > -- Andreas Guelzow _______________________________________________ gnumeric-list mailing list gnumeric-list gnome org http://mail.gnome.org/mailman/listinfo/gnumeric-list -- http://parrenin.frederic.free.fr/