RosettaCodeData/Task/Identity-matrix/Excel/identity-matrix.excel
2023-07-01 13:44:08 -04:00

13 lines
183 B
Text

IDMATRIX
=LAMBDA(n,
LET(
ixs, SEQUENCE(n, n, 0, 1),
x, MOD(ixs, n),
y, QUOTIENT(ixs, n),
IF(x = y,
1,
0
)
)
)