Excel 365 LET Function not recognized

New Contributor


I just upgraded to Office 365 ProPlus

The LET function is not available.

Does anybody know how to fix this issue?

\Thank you


5 Replies
best response confirmed by AndresCMC (New Contributor)


Most probably you are on semi-annual channel, if so update on Current one.

@Sergei Baklan  You're the man!

Thank you!

@AndresCMC , you are welcome

@Sergei Baklan If on a semi-annual enterprise channel then likely I cannot switch  or update on the current one ?
Is there any other way to get this feature ?  It would be extremely helpful with my work but it would be near impossible to have our admins change anything in this space.

Thanks in advance.  


How to change the channel is here That's only IT administrator could change it; or you may change yourself if you have administrative rights on your machine and that's not against your organization policy.


And there are 3 versions of semi-annual enterprise (1908, 2002 and 2008, latest is exists with preview). Not if LET() is on some of it, you may check release notes here