Returns the unit matrix for the specified dimension.
الصيغة
MUNIT(dimension)المعاملات
dimensionمطلوب
The integer specifying the number of rows and columns for the square matrix.
The MUNIT function creates an identity matrix of a given size. An identity matrix is a square matrix where all elements on the main diagonal are equal to 1, and all other elements are equal to 0.
=MUNIT(2)→{1,0;0,1}Creates a 2x2 identity matrix.
Select a cell
Click on the cell where you want the matrix to begin.
Enter the formula
Type =MUNIT(n) where n is the desired dimension and press Enter.
Excel will truncate the number to an integer or return a #VALUE! error if the input is invalid.