Wednesday 26 April 2017

Excel - Microsoft Excel MDETERM Function

Description

The Excel MDETERM function calculates the determinant of a square matrix. 

The format of the function is : 

MDETERM( array ) 

where the array argument is an array of numerical values, that represent a square matrix (i.e. has the same number of rows as columns). 

Mdeterm Function Examples

In the examples below, the Excel Mdeterm function is used to calculate the determinant of a 2x2 and a 3x3 matrix. 

Mdeterm Function Error
If you get an error from the Excel Mdeterm Function, this is likely to be the #VALUE! error: 

Common Error 


No comments:

Post a Comment