lambda-basic-iife |
LAMBDA |
=LAMBDA(x, x+1)(5) |
value |
|
lambda-two-args |
LAMBDA |
=LAMBDA(x, y, x*y)(3, 4) |
value |
|
lambda-nested |
LAMBDA |
=LAMBDA(x, LAMBDA(y, x+y))(1)(2) |
value |
|
lambda-as-higher-order |
LAMBDA |
=LAMBDA(f, f(5))(LAMBDA(x, x*2)) |
value |
|
let-basic |
LET |
=LET(x, 5, x+1) |
value |
|
let-multiple-bindings |
LET |
=LET(x, 3, y, 4, x+y) |
value |
|
let-scoping |
LET |
=LET(x, 1, y, x+1, z, y+1, z) |
value |
|
map-over-column |
MAP |
=MAP({1;2;3}, LAMBDA(x, x*2)) |
value |
|
map-over-row |
MAP |
=MAP({1,2,3}, LAMBDA(x, x*10)) |
value |
|
map-two-arrays |
MAP |
=MAP({1;2;3}, {10;20;30}, LAMBDA(a, b, a+b)) |
value |
|
reduce-sum |
REDUCE |
=REDUCE(0, {1;2;3;4;5}, LAMBDA(acc, x, acc+x)) |
value |
|
reduce-product |
REDUCE |
=REDUCE(1, {1,2,3,4,5}, LAMBDA(acc, x, acc*x)) |
value |
|
reduce-string-concat |
REDUCE |
=REDUCE("", {"a";"b";"c"}, LAMBDA(acc, x, acc&x)) |
value |
|
scan-cumulative-sum |
SCAN |
=SCAN(0, {1;2;3;4;5}, LAMBDA(acc, x, acc+x)) |
value |
|
filter-basic |
FILTER |
=FILTER({1;2;3;4;5}, {1;0;1;0;1}) |
value |
|
filter-with-condition |
FILTER |
=FILTER(A1:A4, A1:A4>10) |
value |
|
filter-no-results |
FILTER |
=FILTER({1;2;3}, {0;0;0}, "none") |
value |
2 |
sort-ascending |
SORT |
=SORT({3;1;2}) |
value |
|
sort-descending |
SORT |
=SORT({3;1;2}, 1, -1) |
value |
|
sortby-basic |
SORTBY |
=SORTBY({10;20;30}, {3;1;2}) |
value |
|
unique-column |
UNIQUE |
=UNIQUE({1;2;1;3;2}) |
value |
|
makearray-multiplication-table |
MAKEARRAY |
=MAKEARRAY(3, 3, LAMBDA(r, c, r*c)) |
value |
|
byrow-sum |
BYROW |
=BYROW({1,2,3;4,5,6}, LAMBDA(row, SUM(row))) |
value |
|
bycol-sum |
BYCOL |
=BYCOL({1,2,3;4,5,6}, LAMBDA(col, SUM(col))) |
value |
|