ExcelBanter - Limits of MINV matrix function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Limits of MINV matrix function (https://www.excelbanter.com/excel-worksheet-functions/45599-limits-minv-matrix-function.html)

Limits of MINV matrix function

Hi,

Does someone know if there are limits when dealing with matrices? I get a
value error if I try to calculate the inverse of a large matrix (68x68
cells). It works up to 52x52 matrices but fails when the matrix is of size
53x53.

To narrow down the problem I defined an identity matrix of dimension 53x53.
{=MINV(A1:AZ52)} works, {=MINV(A1:BA53)} doesn't whereas MMULT of the
identity matrix itself does, no matter of the size of it's dimensions, e.g.
{=MMULT(A1:BA53;A1:BA53)} works perfectly well.

Any idea welcome.

Regards
KJ

Laurent Longre's MoreFunc.xll includes a MINVERSE.EXT function that will
invert larger matrices.

http://xcell05.free.fr/

Jerry

KJ wrote:

Hi,

Does someone know if there are limits when dealing with matrices? I get a
value error if I try to calculate the inverse of a large matrix (68x68
cells). It works up to 52x52 matrices but fails when the matrix is of size
53x53.

To narrow down the problem I defined an identity matrix of dimension 53x53.
{=MINV(A1:AZ52)} works, {=MINV(A1:BA53)} doesn't whereas MMULT of the
identity matrix itself does, no matter of the size of it's dimensions, e.g.
{=MMULT(A1:BA53;A1:BA53)} works perfectly well.

Any idea welcome.

Regards
KJ

Hi Jerry,

it works perfectly well.

Thanks.
KJ

Laurent Longre's MoreFunc.xll includes a MINVERSE.EXT function that will
invert larger matrices.

http://xcell05.free.fr/

Jerry