On Tuesday February 27 2007 10:42 am, Manuel Angel wrote:
> I am using OpenOffice.org 2.1 and the problem is related with
> product of matrix (function MMult).
> When some elements of your matrices are 'blanks' the program report
> an error and you have to introduce '0' in each element to calculate
> the product.
>
> Thanks
>
>
> Manuel Ángel Barragán
> [EMAIL PROTECTED]
It is the way two matrices are multiplied together that requires
this. The first element of the first row of the first matix (going
left to right) is multiplied by the first element of the first column
(going from top to bottom) of the second matrix. Then the second
element of the first row of the first matrix is multiplied by the
second element of the first column of the second matrix. And this
continues until the last element of the first row in the first matix
is multiplied by the last element of the first column of the second
matrix. All of these products are added together to determine the
first element of the first row of the "product" matix. And this
process continues until every element of the "product" matrix is
calculated. But this should be sufficient to show what there can be
no "blanks" in a matrix if you are going to multiply it with another
matrix. Some of the products I mentioned can not be done with
a "Blank" cell in the matrix. That means that most if not all of the
additions can not be done either. Thus, #Value! is the result.
If this is clear as mud, I could send you a description of
multiplying two 2X2 matrices.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
