ExcelFlux

MINVERSE function

the matrix inverse of an array.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Invert a diagonal matrix. Nonzero diagonal values become reciprocals.

A worked example from the workbook

RowABC
6InputSecond inputPosition
7201
8042
9001
Record 1
=INDEX(MINVERSE($A$7:$B$8),C7,C7)

Expected result0.5

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=INDEX(MINVERSE($A$7:$B$8),C7,C7)
Turkish Excel · tr-TR
=İNDİS(DİZEY_TERS($A$7:$B$8);C7;C7)

Worked examples

Invert a diagonal matrix. Nonzero diagonal values become reciprocals.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Input Second input Position
7 2 0 1
8 0 4 2
9 0 0 1
Case Formula Expected result
Record 1 =INDEX(MINVERSE($A$7:$B$8),C7,C7) 0.5
Record 2 =INDEX(MINVERSE($A$7:$B$8),C8,C8) 0.25
Record 3 =INDEX(MINVERSE($A$7:$B$8),C9,C9) 0.5
Microsoft Excel reference