Spread Formula Reference
Formula Functions / Functions M to Q / MDETERM
In This Topic
    MDETERM
    In This Topic

    This function returns the matrix determinant of an array.

    Syntax

    MDETERM(array)

    Arguments

    The array is a numeric array that has an equal number of columns and rows.

    Arrays can be a cell range. If any of the array cells are empty or contain text then an error is returned.

    Data Types

    Accepts an array. Returns numeric data.

    Examples

    MDETERM(A3:E7)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    MINVERSE | MMULT | Math and Trigonometry Functions