Forum Discussion

Former Employee

Jun 05, 2020

LET – Names in formulas for Excel

Hello all, I'm excited to share with you a new function that has been recently released, Names in formulas or =LET(). The LET function will now allow you to name and then use a calculation or ...

Formulas and Functions

Copper Contributor

Aug 20, 2020

Evan_Bolin Trying to test new LET function Excel for Mac. Downloaded FAST version. Now: Version 16.41 (20081900). Function is not there. Article says I should have it: https://insider.office.com/en-us/blog/let-names-in-formulas-for-excel. Thoughts?

Evan_Bolin
Former Employee
Aug 20, 2020
Hello bScottS

At this time, this feature is currently only available to a portion of Office Insiders while we continue to optimize this feature over the next several months. You may gain access to the function after installing future updates.

Thanks,

Evan
- bScottS
  Copper Contributor
  Aug 20, 2020
  Evan_Bolin One more thing, for what it's worth. I didn't even have the FAST version of Excel installed, only PRODUCTION, but this morning I received an announcement about the new LET function from Excel, and that's why I started looking into it and downloaded the FAST version. It seems that Microsoft shouldn't be having new feature pop-ups happening in Excel if the feature is not yet available.
  - SergeiBaklan
    Diamond Contributor
    Aug 20, 2020
    bScottS , just for my interest - is that Excel for Mac where you have such pop-ups?
- bScottS
  Copper Contributor
  Aug 20, 2020
  Thanks Evan_Bolin. I guess that online article was misleading.
  - bScottS
    Copper Contributor
    Aug 23, 2020
    Ironically, the LET function started working the next day after my computer had been rebooted. It really is a great function and I look forward to testing it in more use case scenarios.