Forum Discussion

Noeotbs's avatar
Noeotbs
Copper Contributor
Jan 22, 2022

I'm having trouble finding the LAMBDA function

When I go to the list of functions, LAMBA is not there, and when I follow examples on Microsoft's website I get a #NAME? error.

I've also downloaded example files and gotten the #NAME? error

Even something simple like =LAMBDA(x,x*x)(3) gives me the error.

 

I haven't been able to find any recent posts about LAMBDA being missing from Excel

Some information I've found says I should have it, but I'm confused. Some older information from 2020 says you have to be an Office Insider, but some newer info from last year says it's now included if you have a 365 subscription.

 

I have a Microsoft Office 365 Family subscription.

Excel Version 2112 (Build 14729.20260 Click-to-Run)

I've checked Office Updates and it says that Excel is up to date.

I'm on Windows 10 Home 10.0.19044 Build 190044

I just checked Windows update and there are no non-optional updates available.

I've rebooted.

That's everything I can think of that anyone might ask.

 

Thanks,

Noe

  • seror 

    So far lambdas are available for Office Insiders only, that means you shall be on Beta or at least on Current (Preview) channel. Build number practically doesn't matter.

    • seror 

      So far lambdas are available for Office Insiders only, that means you shall be on Beta or at least on Current (Preview) channel. Build number practically doesn't matter.

      • seror's avatar
        seror
        Copper Contributor
        Thank you for your answer. I fixed it.:)

Resources