*From*: Andreas Guelzow <aguelzow pyrshep ca>*To*: gnumeric-list gnome org*Subject*: Re: multiplication of matrices*Date*: Wed, 17 Aug 2011 11:28:24 -0600

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 <aguelzow pyrshep ca>

**Follow-Ups**:**Re: multiplication of matrices***From:*Frederic Parrenin

**References**:**multiplication of matrices***From:*Frederic Parrenin

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]