MMULT Function in Excel: Syntax, Examples and Free Practice
MMULT is an Excel Math & Trig function. Returns the matrix product of two arrays.
MMULT syntax
=MMULT(array1, array2)
Arguments
array1: The first range or arrayarray2: The second range or array
When to use MMULT
MMULT is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice MMULT online, free
Open the live Excel-style spreadsheet and try MMULT yourself. No Excel install or sign-up needed to start.
Practice MMULT now →More Math & Trig functions
Frequently asked questions
What does the MMULT function do in Excel?
Returns the matrix product of two arrays.
What is the syntax of MMULT in Excel?
The syntax is =MMULT(array1, array2). array1: The first range or array; array2: The second range or array.
Where can I practice MMULT online for free?
Open the free live spreadsheet on Cellgrids and try MMULT yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts