SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1895895%22%20slang%3D%22en-US%22%3EIFS()%20function%20not%20available%20despite%20using%20the%20latest%20Excel%20version%20and%20subscribing%20to%20Microsoft%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1895895%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20use%20the%20IFS()%20function%20in%20Excel%2C%20eg.%20in%20a%20cell%20formula.%20When%20opening%20xlsx%20files%20containing%20such%20a%20formula%2C%20it%20gets%20turned%20into%20%22_xlfn.IFS%22%20as%20soon%20as%20Excel%20wants%20to%20update%20the%20sheet's%20calculations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Help%20suggests%20that%20I%20need%20a%20MS%20365%20subscription%20and%20the%20latest%20Excel%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I've%20just%20purchased%20a%20MS%20365%20subscription%2C%20allowed%20AutoUpdate%20to%20install%20the%20latest%20version%20(which%20is%3A%20Microsoft%20Excel%20for%20Mac%20Version%2016.43)%20and%20logged%20into%20my%20account%20with%20Excel.%20The%20About%20box%20says%3A%20License%3A%20Microsoft%20365%20Subscription.%20Belongs%20to%3A%20(myaccount-email)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20everything%20should%20be%20in%20order%2C%20it%20seems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYet%2C%20IFS()%20is%20not%20recognized%2C%20showing%20%22%23NAME%3F%22%20in%20the%20cell%20instead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20same%20xlsx%20file%20works%20fine%20on%20a%20collegue's%20Mac%2C%20so%20it's%20not%20the%20Excel%20file%2C%20it's%20something%20with%20my%20setup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20running%20on%20macOS%2010.13.6%2C%20in%20case%20that%20matters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1895895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1896385%22%20slang%3D%22en-US%22%3ERe%3A%20IFS()%20function%20not%20available%20despite%20using%20the%20latest%20Excel%20version%20and%20subscribing%20to%20Microsoft%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1896385%22%20slang%3D%22en-US%22%3ENevermind%20-%20the%20issue%20resolved%20itself%20magically%2C%20suddenly.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20had%20of%20course%20restarted%20Excel%20and%20that%20did%20not%20help.%20Now%2C%20about%20an%20hour%20later%2C%20I%20relaunch%20Excel%20again%2C%20and%20it%20AGAIN%20asks%20me%20about%20some%20privacy%20confirmations%20that%20I%20had%20already%20confirmed%20after%20installing%20the%20program%20earlier.%20And%20this%20time%2C%20the%20IFS%20function%20works.%3CBR%20%2F%3E%3CBR%20%2F%3ETerrible%20user%20experience.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 calculations.

 

The Help suggests that I need a MS 365 subscription and the latest Excel version.

 

So I've just purchased a MS 365 subscription, allowed AutoUpdate to install the latest version (which is: Microsoft Excel for Mac Version 16.43) and logged into my account with Excel. The About box says: License: Microsoft 365 Subscription. Belongs to: (myaccount-email)

 

So, everything should be in order, it seems.

 

Yet, IFS() is not recognized, showing "#NAME?" in the cell instead.

 

The same xlsx file works fine on a collegue's Mac, so it's not the Excel file, it's something with my setup.

 

I am running on macOS 10.13.6, in case that matters.

 

1 Reply
Highlighted
Best Response confirmed by tempelorg (New Contributor)
Solution
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.