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. You submit array formulas with special keyboard shortcuts. We recommend that you use the unconstrained keyboard shortcut Ctrl+Alt+Enter (on Windows) or Command+Option+Enter (on Mac) so Worksheets can use all the cells it needs for the results. For more information, see Reference: Array Formula Keyboard Shortcuts.