MMULTI Function

Question

I keep having. a value error no matter how I do it, on my mac

Answer 1

Hi, I'm John! I will help you with this.

1. Are both ranges purely numeric?
2. Do the array sizes match properly (e.g., 2x3 multiplied by 3x2)?
3. Are you selecting the correct output size?

On Mac, also try this:

• Enter the formula normally first
• If it still errors, try confirming with Cmd + Shift + Enter (older Excel versions may still need this)
• Example: =MMULT(A1:B2, D1:E2)

---

If possible, can you share:

• The exact formula you're using
• The sizes of the two ranges

That will help narrow down exactly why you're getting #VALUE.

Click "Add comment" to let me know.

Regards,

John J.D.

Answer 2

The function name in Excel is MMULT, not MMULTI. Using MMULT incorrectly will cause a #VALUE! error on Mac just as on Windows.

To avoid the #VALUE! error with MMULT on Mac:

1. Check the function name
   • Use =MMULT(array1, array2) (no extra “I”).
2. Make sure matrix sizes are compatible
   • The number of columns in array1 must equal the number of rows in array2.
   • Example: if array1 is a 2×3 range, array2 must be 3×N (any number of columns N).
   • If this condition is not met, MMULT returns #VALUE!.
3. Ensure all cells are numeric
   • Both arrays must contain only numbers.
   • Any text, blanks, or non-numeric values in the ranges will cause #VALUE!.
4. Enter as an array formula if not using dynamic arrays
   • On current Microsoft 365 versions, type the formula in the top-left output cell and press ENTER; Excel spills the result automatically.
   • On older Excel versions for Mac, select the full output range first, type the MMULT formula in the top-left cell, then press CTRL+SHIFT+ENTER to confirm it as an array formula. Excel will show {=MMULT(... )} in the formula bar.
   • If MMULT is used as an array formula but not confirmed correctly, a #VALUE! error can appear.
5. Verify the output range size
   • The result will have:
     • rows = number of rows in array1
     • columns = number of columns in array2
   • When using legacy array formulas, select exactly that size before confirming with CTRL+SHIFT+ENTER.

If any of these conditions (correct name, matching dimensions, numeric-only cells, correct array entry) are not met, MMULT will return #VALUE! on Mac.

---

References:

• MMULT function
• How to correct a #VALUE! error