ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   calculation of Determinant of a matrix (https://www.excelbanter.com/excel-worksheet-functions/114528-calculation-determinant-matrix.html)

Rasoul Khoshravan

calculation of Determinant of a matrix
 
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

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.




All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com