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 containg blanks (treating blanks as 0). I read that using the formula N() would solve the problem, but it doesn’t – probably N() does not work on matrices.
Any help would be appreciated!
What I need is simple and described in the subject: I would like to multiply matrices that containg blanks (treating blanks as 0). I read that using the formula N() would solve the problem, but it doesn’t – probably N() does not work on matrices. Any help would be appreciated! Read More