MMULT(A1:B2;TRANSPOSE(A3:B3))

  • Thread starter Thread starter sensorflo
  • Start date Start date
S

sensorflo

Hello

I try to multiply a matrix with a vector. The matrix is in A1:B2, the
vector is in A3:B3. Thus I need to tranpose the vector first. I tried:
=MMULT(A1:B2;TRANSPOSE(A3:B3))
However this results in "#VALUE!". What is wrong? Since the actual
problem is more complex, I cant store the vector in another way into
cells, so that it would be already in the correct form.

Greetings

Flo
 
Did you hit ctrl-shift-enter and did you have a range of 2 rows by 1 column
selected when you array entered the formula.

Excel's help explains it more thoroughly.
 
Back
Top