View Single Post
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

"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)