Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a generalized inverse matrix | Excel Discussion (Misc queries) | |||
Matrix Inverse | Excel Worksheet Functions | |||
How to compute the inverse of a matrix with some complex elements | Excel Worksheet Functions | |||
log inverse | Excel Discussion (Misc queries) | |||
Matrix inverse | Excel Programming |