that formula for example defines a lambda function which returns a function that generates a times table array. Hence times_table_generator(6)(12) - the 6 times table with 12 elements.
sorry, thought that was so crazy, had to share!
And this=LET(times_table_generator,LAMBDA(base, LAMBDA(elems,SEQUENCE(elems)*base)), times_table_generator(SEQUENCE(1,12))(12)) is a 12x12 array of all the times tables
IIUC, a lambda is an inline, unnamed function. But now you can have a lambda (unnamed, inline function) that returns a function? Is that a named function that can then be called elsewhere?
I think these new functions entirely negate the use of VBA for udfs, except side effecting ones and ones which require static memory or referencing libraries.
No the secondary function isn't named, and a cell can't store an anonymous function. You have to use them straight away or save the top level first order function in the name manager
You see the second order function is immediately consumed in my example, although you can temporarily name it using the LET function which is quite neat I think