Spread.NET 18 Formula Reference
Formula Functions / Functions M to Q / MINVERSE
In This Topic
    MINVERSE
    In This Topic

    This function returns the inverse matrix for the matrix stored in an array.

    Syntax

    MINVERSE(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.

    Remarks

    Use the INDEX function to get individual elements from the returned array.

    Data Types

    Accepts an array. Returns an array.

    Examples

    MINVERSE(A3:E7)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    MDETERM | MMULT | Math and Trigonometry Functions