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