Array FunctionsAdvanced

MDETERM Function

Calculate the determinant of a matrix.

Task:

You need to find the determinant of a matrix. Calculate the determinant of the matrix in A2:B3 using the MDETERM function and display the result in B4.

Interactive Spreadsheet

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of MDETERM Function

0/2

The same formula in the other shapes it takes at work.

  1. MDETERM Function

    Calculate the determinant of a matrix.

    CoreAdvanced
  2. MDETERM to test whether a system has one answer

    A determinant of zero means the equations do not pin down a unique solution.

    Advanced

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

4 rows × 2 columns1 cell you fill in
AB
1Matrix
247
326
4Determinant

Functions used here

What this exercise teachesMay contain the answer

MDETERM calculates the matrix determinant, a scalar value used in linear algebra.