0

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?

enter image description here enter image description here

enter image description here

Improve this question

2 Answers 2

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

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)))

enter image description here

Output

enter image description here

Cheers!

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.