MIDENTITY
Description
Returns a mathematical identity matrix.
Syntax
MIDENTITY(
value
)
- value: The dimension of the resulting matrix.
Example
Formula | Result |
|---|---|
=MIDENTITY(3) | 1 0 0
0 1 0
0 0 1
|
Notes
- This function returns a mathematical identity matrix. In an identity matrix, all the values in the matrix are zero except for values in the diagonal (from upper left to lower right), which are set to one.
- This function is intended for use in array formulas.