Forum Discussion
FV16
Jan 07, 2025Copper Contributor
MINVERSE different results from online calculators
I noticed that the results of the MINVERSE function differs from the results of the several online calculators that I've tried. Any thought on this?
HansVogelaar
Jan 08, 2025MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
FV16
Jan 11, 2025Copper Contributor
Hi there,
Below is a sample 6x6 matrix. I've checked the results against at least three online calculators and all of them give an answer of -1.41 for cell (6,6). And no, it's not a rounding off error.
- HansVogelaarJan 13, 2025MVP
This is what I see:
I am using Excel in Microsoft 365, version 2412.
- FV16Jan 18, 2025Copper Contributor
That is odd because when I tried to replicate this from a completely blank sheet I also got the same results as you.
- HansVogelaarJan 21, 2025MVP
Without seeing the "problem" worksheet it is impossible to know what caused the error.