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

4 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.

     

    • Gilles_53's avatar
      Gilles_53
      Copper Contributor
      Jun 09, 2026

      Thank you for the test.

      It made me crasy to look around not knowing what was rong. So with your test I am sure that my syntaxe was good.

      But there is realy a bug on my Excel Version ; see comment on Hecatonchire message below

    • Gilles_53's avatar
      Gilles_53
      Copper Contributor
      Jun 09, 2026

      I think You are right ! I am running an LTSC version : Microsoft® Excel® LTSC MSO (16.0.14334.20688) 64 bits

      And I have other bugs with Excel Lab to ; the Grid tab is not Working : seems to be an API function missing, for this bug.

       

      But for Lambda, it shoud be an other one !

       

      But I read that LAMBDA function exist since near 2010 so my LTSC version is far after !!!