b7e2b2 |
LAMBDA |
=LAMBDA(x, x+1)(5) |
value |
|
fa6a6a |
LAMBDA |
=LAMBDA(x, y, x*y)(3, 4) |
value |
|
acdb81 |
LAMBDA |
=LAMBDA(x, LAMBDA(y, x+y))(1)(2) |
value |
|
c937f1 |
LAMBDA |
=LAMBDA(f, f(5))(LAMBDA(x, x*2)) |
value |
|
0437b6 |
LET |
=LET(x, 5, x+1) |
value |
|
e0b0a1 |
LET |
=LET(x, 3, y, 4, x+y) |
value |
|
294b68 |
LET |
=LET(x, 1, y, x+1, z, y+1, z) |
value |
|
1f007f |
MAP |
=MAP({1;2;3}, LAMBDA(x, x*2)) |
value |
|
44fa4e |
MAP |
=MAP({1,2,3}, LAMBDA(x, x*10)) |
value |
|
0554fb |
MAP |
=MAP({1;2;3}, {10;20;30}, LAMBDA(a, b, a+b)) |
value |
|
d11210 |
REDUCE |
=REDUCE(0, {1;2;3;4;5}, LAMBDA(acc, x, acc+x)) |
value |
|
f1924f |
REDUCE |
=REDUCE(1, {1,2,3,4,5}, LAMBDA(acc, x, acc*x)) |
value |
|
cf90e6 |
REDUCE |
=REDUCE("", {"a";"b";"c"}, LAMBDA(acc, x, acc&x)) |
value |
|
8f5b11 |
SCAN |
=SCAN(0, {1;2;3;4;5}, LAMBDA(acc, x, acc+x)) |
value |
|
7deee0 |
FILTER |
=FILTER({1;2;3;4;5}, {1;0;1;0;1}) |
value |
|
0fc896 |
FILTER |
=FILTER(A1:A4, A1:A4>10) |
value |
|
c2caf0 |
FILTER |
=FILTER({1;2;3}, {0;0;0}, "none") |
value |
2 |
c67420 |
SORT |
=SORT({3;1;2}) |
value |
|
f4d3f6 |
SORT |
=SORT({3;1;2}, 1, -1) |
value |
|
c2fc06 |
SORTBY |
=SORTBY({10;20;30}, {3;1;2}) |
value |
|
2ce972 |
UNIQUE |
=UNIQUE({1;2;1;3;2}) |
value |
|
50c426 |
MAKEARRAY |
=MAKEARRAY(3, 3, LAMBDA(r, c, r*c)) |
value |
|
4c3944 |
BYROW |
=BYROW({1,2,3;4,5,6}, LAMBDA(row, SUM(row))) |
value |
|
c82f4f |
BYCOL |
=BYCOL({1,2,3;4,5,6}, LAMBDA(col, SUM(col))) |
value |
|