Solving matrix in excel

If your data is in A1 to C2 then write this formula in for example E1:

=-1*A1

and extend right and down

Actually it's a dynamic range f76:y94 cells ( that is maximum of range ) that could shrink to only 2 cells - f76 ; f77.

I have a formula =MINVERSE(DROP(F76#;;-1)) in f102 cell that do what i wish to solve matrix,but only in these 2 cases that I've point formula gives #NUM! error and I don't know how to solve that task.

That's mean given matrix

-1,00 1,00 -1,00
1,00 -1,00 -1,00

is in range f76:h78.

According to https://support.microsoft.com/en-us/...9-59da2d72efc6 MINVERSE finds the inverse of a square matrix.
Since your range is f76:h78 it appears that H76:H78 are zeros (blanks).
According to https://www.symbolab.com/solver/matr...ix%7D?or=input "A matix with a zero row is not invertible."

Originally Posted by JeteMc

According to https://support.microsoft.com/en-us/...9-59da2d72efc6 MINVERSE finds the inverse of a square matrix.
Since your range is f76:h78 it appears that H76:H78 are zeros (blanks).
According to https://www.symbolab.com/solver/matr...ix%7D?or=input "A matix with a zero row is not invertible."

Thank you for your answer,JeteMc! But it's my wrong - range is f76:h77 . It's strange that =MINVERSE(DROP(F76#;;-1)) solve that matrix

-1,00 1,00 -1,00
1,00 -6,00 -1,00 range is f76:h77

but not that

-1,00 1,00 1,00 -1,00
1,00 -2,00 1,00 -1,00
1,00 1,00 -5,00 -1,00 range is f76:i78

Why is it strange? What result do you expect?

As near as I can tell, the first matrix is invertible, while the second matrix is not. If I enter =MDETERM(DROP(F76#,,-1)), then I get 5 for the determinant of the first matrix and 0 for the second. It is well known that the determinant of a matrix must be non-zero for the matrix to be invertible. If this is mostly a question of having a clear indicator of when a matrix is invertible and when it isn't, I might calculate the determinant somewhere as an visual indicator that the matrix is or is not invertible.