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.
Based on screenshot it's hard to check which formulas and how do you use, better to have sample file. Variants could be
- Something very strange is happening, unless my age has turned me senile. I worked extensively with Excel 20 years ago, when it didn't insert things I didn't type. I've just used the matrix you use. Without the braces I get a single entry of 6.49852. With braces I get just the formula, i.e., it doesn't recognize the = sign. When I first used MINVERSE successfully it inserted the braces for me, outside the = sign, I think. I could send the entire spread sheet, but now I don't know where to attach it.
vicvanlint , yes, better to play with spreadsheet. Replying on post you shall see at the bottom
browse the file to attach it.
