Lambda and LET do not work!

Question

In the example provided in the attached file, I can't combine a Lambda statement with a LET statement.

To execute it, I simply need to put an "=" before the formula.

I've copied the error message into the file.

Note that my separator is a semicolon, not a comma.

I encountered this error in the past with the "Premium" version and had to downgrade to the Home version!

What should I do? Wait for a bug fix?

Your system won't let me include a file with an XLSX extension!

Thanks

Answer 1

Hello Francisco**,**

My Excel 365 is up to date; I have version 16.105 (26011018) and am running on the latest version of macOS.

Here is the formula:

LAMBDA(Last;Date_Int;DoB;Interval;Fin;

LET(S1;if(Last=0;date(year(Date_int);month(Date_int)+Interval+day(Date_int));date(year(Last);month(Last)+Interval+day(Last)));

Suivant;if(S1>date(year(DoB)+Fin;month(DoB);day(DoB));"Superflu!";S1);

Suivant))(B2;C2;D2;48;60)

And the error I'm getting is:

Answer 2

Hi Daniel,

As a first step, do this for me. In any empty cell type =LAMBDA(x, x+1)(5) using your local list separator.

• If you get 6, LAMBDA works and the issue is your formula.
• If you get a NAME error, your Excel version lacks LAMBDA. Update Microsoft 365 to the latest Current Channel in File > Account > Update Options > Update Now, then restart Excel. Note that perpetual Office 2019 or 2021 does not support LAMBDA, while LET does.