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 |
