Forum Discussion

tempelorg's avatar
tempelorg
Copper Contributor
Nov 17, 2020
Solved

IFS() function not available despite using the latest Excel version and subscribing to Microsoft 365

I cannot use the IFS() function in Excel, eg. in a cell formula. When opening xlsx files containing such a formula, it gets turned into "_xlfn.IFS" as soon as Excel wants to update the sheet's calcul...
  • tempelorg's avatar
    Nov 17, 2020
    Nevermind - the issue resolved itself magically, suddenly.

    I had of course restarted Excel and that did not help. Now, about an hour later, I relaunch Excel again, and it AGAIN asks me about some privacy confirmations that I had already confirmed after installing the program earlier. And this time, the IFS function works.

    Terrible user experience.

Resources