Forum Discussion

Copper Contributor

Dec 07, 2020

LAMBDA formula not available

I' am a 365 subscriber. Windows 10 user all up to date. I deleted my current install of office and reinstalled a 64 bit ver with the correct ver of office 16.0.13426.203308. yet LAMBDA doesn't show u...

Formulas and Functions

NikolinoDE

Gold Contributor

Dec 07, 2020

x2dull4u

A few pieces of information, maybe this will help you:

Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

If necessary update Windows to the latest version

Announcing LAMBDA: Turn Excel formulas into custom functions

LAMBDA function

=LAMBDA([parameter1, parameter2, …,] calculation)

Announcing LAMBDA (microsoft.com)

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

Sonu_CA

Copper Contributor

Feb 06, 2022

Correction: This functionality is available ONLY for Office Insider, as of 02/06/2022. Just as our friend SergeiBaklan stated below.

CareySmithDuke
Copper Contributor
Feb 09, 2022
So this function is still not available and in beta for 2 years? At this point will it ever be included in the general release?
- mtarler
  Silver Contributor
  Feb 09, 2022
  This just recently got released to current channel so try to force an update, that is what worked for me.
  - DKoontz
    Iron Contributor
    Feb 10, 2022
    mtarler
    
    Hi, how were you able to force an update? About shows I'm on the latest build and current channel but when I go to update, office tells me I'm on the latest version.
    I'm so excited to try it out, thanks!
- SergeiBaklan
  Diamond Contributor
  Feb 09, 2022
  CareySmithDuke
  
  It is already added to current channel https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambdas-to-production-and-advanced-formula/bc-p/3138594#M2525 deployment could take up to month or two.
  
  If you are on semi-annual channel - afraid another year to wait or so.