Forum Discussion

Copper Contributor

Jun 15, 2021

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.

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jun 20, 2021

vicvanlint

Thank you for the file. In the formula there is implicit intersection operator "@" which returns first element of the array

If use formula without it result will be expected matrix.

Operator could appear if open in older Excel the file created in Excel which supports dynamic arrays.

Book3 (1) (1).xlsx11 KB

vicvanlint

Copper Contributor

Jun 20, 2021

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.

SergeiBaklan
Diamond Contributor
Jun 20, 2021
vicvanlint

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)