MUNIT Function in Excel – Create unit Matrix in Excel

MUNIT Function in Excel creates a unit matrix of specified dimension

Syntax of MUNIT Function in Excel

Where dimension is an integer value that specifies the dimension of the unit matrix

 

Example of MUNIT Function in Excel

Let’s see how to create unit matrix in excel using MUNIT Function step by step (we will be using 3×3 matrix as an example).

Step 1: Select 3X3 Cells where you want to create unit matrix as shown below

Step 2: In the formula section specify MUNIT Function with dimension as input   i.e. =MUNIT(3)

 

Step 3: press Ctrl+Shift+Enter to get the unit matrix of 3×3. So the resultant unit matrix is shown below