Nov 17 2020 07:56 AM
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.
Nov 17 2020 08:23 AM
SolutionNov 17 2020 08:23 AM
Solution