Forum Discussion
Solved
How to use MMULT() when array contains blanks?
What I need is simple and described in the subject: I would like to multiply matrices that contain blanks (treating blanks as 0). I read that using the formula N() would solve the problem, but it...
Or alternatively do some arithmetic which doesn't change the values, e.g.
=MMULT(1*array1,array2)
