deepcalc
DocsMDETERM

MDETERM

View as markdown/docs/functions/mdeterm.md Ask Claude about this pageOpens Claude with this page's address

Returns matrix determinant of an array.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=MDETERM(A1:B2)
AB
1 102
2 204
Result 0

Syntax

MDETERM(array)
array
range required

Errors

#VALUE!
=MDETERM(A1:C2)
#ERROR!
=MDETERM(1,2)
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.