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

MUNIT( dimension)

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

MUNIT Function in Excel 1

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

MUNIT Function in Excel 2

 

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

MUNIT Function in Excel 3

previous MUNIT Function in Excel                                                                                                                next MUNIT Function in Excel