Forum Discussion
MINVERSE - Difference in result between EXCEL and MATLAB
Some of the matrix entries have formulas that refer indirectly to column I.
Column I contains circular references, preventing the worksheet from being recalculated properly.
If you select P2:AH20, copy then paste as values to get rid of the formulas, the inverse matrix will be recalculated correctly and show the same result as MATLAB.
HansVogelaar thank you for your reply, much appreciated. I got the matrix inverse to recalculate to be the same as MATLAB. At least for my own sanity, I'm glad I wasn't doing something completely wrong.
If I may, can I ask a further question.
I do understand what you are saying as regards the column I, and the circular reference. What is continuing to confuse me is that the values in the I column eventually give the values in the matrix that I was trying to get the inverse of. The matrix is not backward dependent on them, it is taking the values from column M and F, so why is the column I causing this difference?
thanks you
Gerard
The formulas in the matrix refer to columns M and F.
The formulas in column M refer to columns E and K.
The formulas in column K refer to columns C, D and J.
The formulas in column J refer to column I.
So the matrix formulas refer indirectly to column I, the column with the circular references.
HansVogelaar thank you for the reply.
I guess what I confused about is the circular reference.
If the formula in column I returns a numerical result, regardless of it been a circular reference, I don't understand how it propagates through to the matrix, as there is a numerical value
Reading around this, enabling iterative calculation seems like an option.
Thanks you for your time and expertise.
Gerard