Forum Discussion
MINVERSE works sometimes on Excel 365, but produces only 1 output on most
On my Excel 365 on Windows 10, MINVERSE works correctly on a 4x4 matrix for a cubic regression, but produces only one output entry for a 3x3 matrix for a quadratic regression to the same data set.
I apologize for my incompetence. I don't know how that got there; it's one of the things that the modern EXCEL is doing to me: inserting stuff I don't intend. Is there any way I can turn off the automatic insertions? I'm perfectly willing to type in the commands, as I used to do until I stopped working about ten years ago. My only excuse is that I'm 93 years old.
My respect.
No, inserting of implicit intersection operator is not configurable. Maybe something is in registry settings, but I don't know about such.
On the other hand this operator appears if you open created in old Excel file in new one to ensure compatibility. Old Excel performs implicit intersection silently in background, to have same result in new Excel you shall use this operator.
More about that is here Implicit intersection operator: @ - Office Support (microsoft.com)