MMULT

Definition: MMULT is a function that returns the matrix product of two given arrays.

Syntax: =MMULT(array1, array2)

Situation: This formula is appropriate when you need to find the matrix product of two given arrays.

Example: If you have two matrix arrays { {1, 2}, {3, 4} } and { {5, 6}, {7, 8} }, the product can be found using the formula =MMULT({{1, 2}, {3, 4}}, {{5, 6}, {7, 8}}), which returns { {19, 22}, {43, 50} }.