ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inverse Matrix (https://www.excelbanter.com/excel-programming/442061-inverse-matrix.html)

Aleatorio

Inverse Matrix
 
Hello everyone. A question.
In VBA environment, the only limit for the calculation of inverse
matrix is the RAM? (I use a function that implements the Gauss-Jordan
Method). I don't care the function WorksheetFunction.MInv().

Thanks.

joel[_939_]

Inverse Matrix
 

Look at the worksheet help under

Limits and specification


There are limits on the number of rows and columns
There are accuracy limits. I think you are limited to 12 bit accuracy
and with floating point number 24 bit binary accuracy.
the execution time is also important.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=198749

http://www.thecodecage.com/forumz



All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com