ExcelFlux

MUNIT function

the unit matrix or the specified dimension.

Math and trigonometry · Excel 2013+

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

Create identity matrices of different sizes. The top-left diagonal element is always one.

A worked example from the workbook

RowA
6Input
71
82
93
Record 1
=INDEX(MUNIT(A7),1,1)

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=INDEX(MUNIT(A7),1,1)
Turkish Excel · tr-TR
=İNDİS(BİRİMMATRİS(A7);1;1)

Worked examples

Create identity matrices of different sizes. The top-left diagonal element is always one.

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
6 Input
7 1
8 2
9 3
Case Formula Expected result
Record 1 =INDEX(MUNIT(A7),1,1) 1
Record 2 =INDEX(MUNIT(A8),1,1) 1
Record 3 =INDEX(MUNIT(A9),1,1) 1
Microsoft Excel reference