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