Descriptive Statistic & Basic Maths functions
EMAP
Reference
» Reference, Discussion, & Example Applications:
About
Lambda helper function that works with up to 4 MAP friendly array arguments.
Same syntax as a regular MAP function. Calls MAPX.
Inputs:
- a : array 1
- b : array 2
- [c] : array 3
- [d] : array 4
- fn : helper Lambda function
Code
M.S. Excel
EMAP = LAMBDA(a, b, [c], [d], fn,
IF(
TYPE(c) = 128,
MAP(MAPX(1, a, b), MAPX(2, a, b), LAMBDA(x, y, c(x, y))),
IF(
TYPE(d) = 128,
MAP(
MAPX(1, a, b, c),
MAPX(2, a, b, c),
MAPX(3, a, b, c),
LAMBDA(x, y, z, d(x, y, z))
),
MAP(
MAPX(1, a, b, c, d),
MAPX(2, a, b, c, d),
MAPX(3, a, b, c, d),
MAPX(4, a, b, c, d),
LAMBDA(x, y, z, w, fn(x, y, z, w))
)
)
)
);
Feedback
Submit and view feedback