Sergei Baklan
Sergei Baklan
By the way, not sure that's a good idea to replace nested IF with IFS...
IFS evaluates all conditions before returns the result. Nested IF stops on first TRUE. From performance point of the the latest is more preferrable. Another point, IFS returns #N/A if...
With last argument as TRUE we meet at least one condition. The question is in different behaviour if no one condition is met.
Okay, they return the same. My point was - with many conditions nested IF works faster, depends on priority of conditions. In general, my impression AFE is died, as many...
Nope, I mean Table=LAMBDA(x, x+1); Group=LAMBDA(x, x+1); Consolidate=LAMBDA(x, x+1); in empty workbook
It looks like all Excel 4.0 macro function names
They are synced with Name Manager, but if we enter in cell something like =Group(2) alert appears "That function isn't valid"
And yes, they don't work with lambdas only, e.g. Group = SUM(Sheet1!a1:a10); works
@jack-williams , now it doesn't sync if we use reserved name function, but the message is not very informative. For beep = lambda(x,y,x+y); itWorks = LAMBDA(x,y, (beep)(x,y) ); doesntWork =...
Didn't catch. Till we add parameters any function is highlighted with error.