Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prolblem entering simple Formulae | Excel Discussion (Misc queries) | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
entering advanced formulae | Excel Worksheet Functions | |||
entering matrix formula | Excel Worksheet Functions |