The MUNIT function returns a unit matrix of size dimension x dimension. The result of this function is an array of form:
1 0 … 0
0 1 ... 0
0 0 … ...
0 0 … 1
Parts of a MUNIT function
MUNIT(dimension)
Part | Description |
dimension |
Required. The size of the unit matrix. Dimension must be an integer greater than zero. |
Sample formulas
Example 1: MUNIT(1)
Example 2: MUNIT(3)
Notes
If dimension is less than 1, MUNIT
returns a #VALUE error.
Examples
Result for A1=MUNIT(1)
A | |
1 | 1 |
2 |
Result for A1= MUNIT(3)
A | B | C | |
1 | 1 | 0 | 0 |
2 | 0 | 1 | 0 |
3 | 0 | 0 | 1 |