Forum Discussion

Gilles_53's avatar
Gilles_53
Copper Contributor
Jun 07, 2026

LAMBDA : function generating #NAME error

Hie,

 

I juste discovered Lambda function, and i have a problem.

 

I created a lambda function that compute a cubiqual polynomial with the code :

Poly3:=LAMBDA(_a, _b, _c, _d, _x, ((_a*_x+_b)*_x+_c)*_x+_d)

Excel accepte de function, but when putting the function in a cell, it generate a #NAME error.

I Debug the Cell, and it seems that de fith argument is refused, with #NAME error !

but the data pasted to the function is a basic computed value !

I don't see anithing rong in my function.

 

Does anyone have an idear, or explaine me what rong in this code ?

Formulas and Functions

2 Replies

  • m_tarler's avatar
    m_tarler
    Silver Contributor
    Jun 08, 2026

    I'm not sure what your issue is.  What do you mean when you say "I debug the cell"?  I tried you LAMBDA 3 different ways and it worked in each case:

    column E has the formula and column F shows the formula so

    the first row is LAMBDA inline with no assignment just the variables directly passed in

    the second row combines with the LET function to assign it to _gilles and then pass the variables into it

    the third row uses the Name Manager (as shown in the name manager window below it) to define the function and then just calling the function with the varibles.

    Maybe give us more information.  Is the problem the variable/number you are passing into it?

    I also just tried it using Excel Labs and entered it as a Function in the Names tab and also as function in the Modules tab and again no issues.