calculation of Determinant of a matrix
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.
"Rasoul Khoshravan" wrote:
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.
|