LAMBDA

%3CLINGO-SUB%20id%3D%22lingo-sub-2117700%22%20slang%3D%22en-US%22%3ELAMBDA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117700%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20tried%20creating%20a%20LAMBDA%20function%20and%20using%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20First%2C%20the%20LAMBDA%20function%20doesn't%20appear%20in%20the%20drop-down%20list%20for%20the%20Excel%20functions.%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20When%20I%20create%20a%20simple%20one%20(%3DLAMBDA(x%2Cy%2Cx%2By))%20a%20NAME%20error%20appears%20in%20the%20cell%20instead%20of%20a%20CALL%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20I%20did%20manage%20to%20create%20a%20LAMBDA%20in%20the%20Name%20Manager%2C%20but%20when%20I%20tried%20using%20it%20with%20date%2C%20again%20I%20got%20the%20NAME%20error%2C%20and%20it%20did%20not%20do%20the%20calculation.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20screenshot%20attached.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2117700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117734%22%20slang%3D%22en-US%22%3ERe%3A%20LAMBDA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959334%22%20target%3D%22_blank%22%3E%40Yaron0202%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20LAMBDA%20is%20not%20in%20the%20list%20of%20functions%20that%20means%20you%20don't%20have%20it.%20So%20far%20it%20is%20available%20for%20insiders%20on%20Beta%20channel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I've tried creating a LAMBDA function and using it. 

1. First, the LAMBDA function doesn't appear in the drop-down list for the Excel functions. 

2. When I create a simple one (=LAMBDA(x,y,x+y)) a NAME error appears in the cell instead of a CALL error. 

3. I did manage to create a LAMBDA in the Name Manager, but when I tried using it with date, again I got the NAME error, and it did not do the calculation. 

 

See screenshot attached.  

1 Reply

@Yaron0202 

If LAMBDA is not in the list of functions that means you don't have it. So far it is available for insiders on Beta channel.