Lambda function calling another lambda function in Excel?

Question

I am trying to create an Excel lambda function that calls another lambda function. But Excel returned #VALUE! when I ran it. Does Excel support this kind of operation?

Answer 1

I found another solution by calling the mylambda1 function within the let function as follows:

mylambda1 = lambda(a, b, a+b)
mylambda2 = lambda(a, b, let(x, a, y, b, mylambda1(x,y)))

Output

Cheers!

Answer 2

mylambda1 takes two arguments, but in mylambda2, you are calling mylambda1 with only one: x+y.

Change mylambda2 to:

=LAMBDA(a,b,mylambda1(a,b))

No need for a LET function in this case.