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 |
| 2 |
Result for A1= MUNIT(3)
| A | B | C |
|---|---|---|
| 1 | 1 | 0 |
| 2 | 0 | 1 |
| 3 | 0 | 0 |