Nice one, Harlan! Never thought of that.

--

Vasant

"Harlan Grove" wrote in message
...
"Ingrid Voigt" wrote...
I've got matrices in my worksheet I'd like to
multiply using MMULT. However, as long as some
of the cells referred to are empty, I can't
get a result. Excel apparently doesn't set the
contents of these cells to 0 as I'd like it to.
...

Since you'd be entering these as array formulas anyway, if RngA and RngB
have blank cells, try

=MMULT(RngA+0,RngB+0)