Matrix Multiplication

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with matrix functions in general. No matter what
variation of sequences I use (the correct one included) I find that Excel
SOMETIMES only returns a portion of the result, one cell, the a11 location.
It is clear that Excel is doing the calculation properly as it is displayed
in the fx window, when the result is an Identity matrix Excel returns a 1 in
a11 location. I know that I have used the same sequence and procedure and
received different results.
I know I must be doing something wrong but cannot figure it out... help
please.
Bill
 
Hi Bill,

You don't mention it, so I'll ask: are you beginning by selecting the full
range of cells that the result of your matrix operation should return? For
example, if the operation should return a 4 X 6 matrix, you need to begin by
selecting a 4 X 6 range of cells, and _then_ array-enter the function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matrix Inversion by Gaussian Reduction 16
Can I invert a matrix in Excel 2007? 2
Sum with matrix functions? 8
Mix/Max/Avg Help based on dynamic ranges 16
calculation of Determinant of a matrix 1
Limits of MINV matrix function 2
Scatter plot / Data from matrices? 1
matrix multiplication 4

Back
Top