Forum Discussion
LAMBDA formula not available
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_CAFeb 06, 2022Copper ContributorCorrection: This functionality is available ONLY for Office Insider, as of 02/06/2022. Just as our friend SergeiBaklan stated below.
- CareySmithDukeFeb 09, 2022Copper Contributor
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?
- mtarlerFeb 09, 2022Silver ContributorThis just recently got released to current channel so try to force an update, that is what worked for me.
- office102globalxyjonJan 15, 2021Copper Contributor
NikolinoDE My office version 2012 (build 13530.20376) but i am not getting Lambda function .....kindly suggest what to do.
- SergeiBaklanJan 15, 2021Diamond Contributor
What is your channel?
If Beta, I assume it shall appear with the second wave. Otherwise you shall to wait more.
- Steve1330Jan 15, 2021Brass Contributor
SergeiBaklan, I Kept looking for it in my home PC MS 365 Excel the past month and finally saw it become available this past weekend. I think I saw something on LnkedIn saying that MS finally rolled it out to the 2nd half of Beta Insiders.
Steve
- x2dull4uDec 07, 2020Copper Contributor
NikolinoDEI did update to the most current windows and It still didn't work, however i learned it's only available to certain people, and I'm not one of those, wish I hadn't update to this stupid subscription crap
Thank you for your help
- NikolinoDEDec 07, 2020Gold Contributor
I didn't know either, thanks to Mr Baklan I now know too.
But what I know about Microsoft is that if the insiders have it now,
they will refine it and soon the rest of the Microsoft population will have it too :).
I am full of confidence when it comes to LAMBDA functionality.
I think this is the next step in evolution for the Excel formulas.
With your permission, believe that you, me and everyone else are on the right track
...but with some things in life, patience can be a virtue.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
- DavidCh0Jan 21, 2022Copper Contributor
NikolinoDE Soon? Still not available to me on Win 11 Office 365 2201 14827.20122.
- x2dull4uDec 07, 2020Copper Contributor