Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating a generalized inverse matrix Ying-Foon Chow Excel Discussion (Misc queries) 10 April 28th 11 11:41 AM
Matrix Inverse Rosina Excel Worksheet Functions 2 May 10th 07 08:49 AM
How to compute the inverse of a matrix with some complex elements Annoushka42 Excel Worksheet Functions 0 March 6th 06 12:08 AM
log inverse Az Excel Discussion (Misc queries) 1 November 28th 05 09:12 AM
Matrix inverse Chee Beng Excel Programming 9 February 19th 04 02:02 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"