In relation to my previous post titled: "Matrix multiplication using
sumproduct"
I also need to calculate the determinant of a matrix.
Is there any add-in or easy way to perform it in Excel?
Writting determinant formula is tedious for me, so if required, I will write
it in next post.
JMB - 17 Oct 2006 00:00 GMT
check help for MDETERM
In help contents, look for Creating Formulas And Auditing
Workbooks/Worksheet Function Reference/Math And Trigonometry Functions -
there are a couple of functions for working w/matrices.
> In relation to my previous post titled: "Matrix multiplication using
> sumproduct"
> I also need to calculate the determinant of a matrix.
> Is there any add-in or easy way to perform it in Excel?
> Writting determinant formula is tedious for me, so if required, I will write
> it in next post.