MMULT function (XL2003)

Topic

New Reply

The MMULT function, multiplying two matrices seems to fail for very large arrays. Does anyone know what its limits are and/or if there is a workaround.

regards

Reply | Quote

Replies

According to MSKB article Description of the limitations for working with arrays in Excel 2000, Excel 2002, and Excel 2003,[indent]

---

The MMULT function returns #VALUE! if the output exceeds 5460 cells.

---

[/indent]Depending on what you want to do with the result, you could write VBA functions to process arrays (matrices).

Reply | Quote