[captainmuon]

This is almost what I always wanted, but it feels a bit bolted on to be honest. I don't like that you have to put a complex nested function in one cell, rather than using multiple cells with temporary results. While this allows you to concatenate Excel functions, I think it doesn't allow you to write a function in "idiomatic" Excel. If I had to implement functions in Excel, I would use one of two strategies:

- You have a special area or special kind of sheet, where some cells are inputs, one is output, and all others are used for temporary calculation

or:

- You define your calculation as usual, in B5: = 10*A5 - then in C5:

    =MYLAMBDA(B5; A5)(3)

Meaning: Take the formula in B5, treat A5 as an argument, and return a function. Then call this function with the argument 3.

The benefit of this? You can have an area in your sheet where the user can enter formulas and multi-cell-calculations, not just numbers, and they are applied elsewhere.