entering a matrix that contains formulae
 

={TRANSPOSE(MMULT({0.999,-0.001,0;0.001,0.999,0;0,0,1},TRANSPOSE(E38:G38)))}

This is my array formula, it works ok, ie the coordinates in E38:G38 are
transformed by the matrix {0.999,-0.001,0;0.001,0.999,0;0,0,1}
What I want to do is replace the values in the matrix with formulae and cell
references, i.e. e.g. instead of 0.999 I want to enter COS(ATAN($Q$33)),
instead of -0.001 I want -sin(ATAN($Q$33))... etc. I get an error when I try
to enter this.

Any ideas? Is it possible to put formulae into imbedded matrices? I do not
want to have a seperately defined matrix.

Cheers

Incoherent

entering a matrix that contains formulae
 

"Incoherent" skrev i en meddelelse
...
={TRANSPOSE(MMULT({0.999,-0.001,0;0.001,0.999,0;0,0,1},TRANSPOSE(E38:G38)))}

This is my array formula, it works ok, ie the coordinates in E38:G38 are
transformed by the matrix {0.999,-0.001,0;0.001,0.999,0;0,0,1}
What I want to do is replace the values in the matrix with formulae and
cell
references, i.e. e.g. instead of 0.999 I want to enter COS(ATAN($Q$33)),
instead of -0.001 I want -sin(ATAN($Q$33))... etc. I get an error when I
try
to enter this.

Any ideas? Is it possible to put formulae into imbedded matrices? I do not
want to have a seperately defined matrix.

Cheers

Incoherent

This formula will do the trick:

=TRANSPOSE(MMULT(CHOOSE({1,2,3;4,5,6;7,8,9},Formul a1,Formula2,Formula3,Formula4,Formula5,Formula6,Fo rmula7,Formula8,Formula9),TRANSPOSE(E38:G38)))

--
Best regards
Leo Heuser

Followup to newsgroup only please.

entering a matrix that contains formulae
 

Beautiful, that works a treat. Thanks a lot.

:)

Incoherent

"Leo Heuser" wrote:

"Incoherent" skrev i en meddelelse
...
={TRANSPOSE(MMULT({0.999,-0.001,0;0.001,0.999,0;0,0,1},TRANSPOSE(E38:G38)))}

This is my array formula, it works ok, ie the coordinates in E38:G38 are
transformed by the matrix {0.999,-0.001,0;0.001,0.999,0;0,0,1}
What I want to do is replace the values in the matrix with formulae and
cell
references, i.e. e.g. instead of 0.999 I want to enter COS(ATAN($Q$33)),
instead of -0.001 I want -sin(ATAN($Q$33))... etc. I get an error when I
try
to enter this.

Any ideas? Is it possible to put formulae into imbedded matrices? I do not
want to have a seperately defined matrix.

Cheers

Incoherent

This formula will do the trick:

=TRANSPOSE(MMULT(CHOOSE({1,2,3;4,5,6;7,8,9},Formul a1,Formula2,Formula3,Formula4,Formula5,Formula6,Fo rmula7,Formula8,Formula9),TRANSPOSE(E38:G38)))

--
Best regards
Leo Heuser

Followup to newsgroup only please.

entering a matrix that contains formulae
 

"Incoherent" skrev i en meddelelse
...
Beautiful, that works a treat. Thanks a lot.

:)

Incoherent


You're welcome.
Thanks for the feedback :-)

Leo Heuser