MDETERM (PQL - xl)

This function returns the matrix determinant of an array

  • Library: PQL \ Spreadsheet \ Math & Trig
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

MDETERM(array)

Function Arguments

Name

Description

Type

Optional

array

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

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'MDETERM' function - using the same inputs, logic and outputs.