=ifna(if(isblank(a1:b2),na(),a1:b2)*d1:e2,"") Should work
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éric 2011/8/17 Andreas Guelzow <aguelzow pyrshep ca>
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>
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
-- http://parrenin.frederic.free.fr/
|
