33 lines
640 B
Text
33 lines
640 B
Text
APPLYN
|
|
=LAMBDA(n,
|
|
LAMBDA(f,
|
|
LAMBDA(x,
|
|
IF(0 < n,
|
|
APPLYN(n - 1)(f)(
|
|
f(x)
|
|
),
|
|
x
|
|
)
|
|
)
|
|
)
|
|
)
|
|
|
|
|
|
APPENDCOLS
|
|
=LAMBDA(xs,
|
|
LAMBDA(ys,
|
|
LET(
|
|
nx, COLUMNS(xs),
|
|
colIndexes, SEQUENCE(1, nx + COLUMNS(ys)),
|
|
rowIndexes, SEQUENCE(MAX(ROWS(xs), ROWS(ys))),
|
|
|
|
IFERROR(
|
|
IF(nx < colIndexes,
|
|
INDEX(ys, rowIndexes, colIndexes - nx),
|
|
INDEX(xs, rowIndexes, colIndexes)
|
|
),
|
|
NA()
|
|
)
|
|
)
|
|
)
|
|
)
|