IFS function not working
Hello, I recently brought a spreadsheet over to a new laptop and the IFS statements that I had been using are no longer recognized. I get the #NAME? error in all cells that are currently using th...
Forum Discussion
Dear Aaron,
IFS function is only available for Office 365 subscribers, it came to Excel with January 2016 updates for Office 365. Follow the below link:
Make sure that you have Office 365 subscription with version 1601 (Build 6568.2025) and above!
If you have in your new laptop an earlier version of Excel or Excel 2016 as a one-time purchase, it is normal to see the #NAME? instead of IFS function, because it's not defined in these versions of Excel.
- Hello Haytham,
I am using office 365 (through my office MAC laptop) and also having the same error. I am using Excel version 16.16.1In general shall work
Perhaps some other reason. If you attach sample file we may check if it works on other platform.
I have attached the sample file from a tutorial i am learning. Please see column F (Age Group). I have also included a screen grab showing details of my Excel version and the excel sheet showing the error.
Hi Fred,
The Excel team says that this function is now available in the latest update to Excel for Mac (version 16.x).
Please read this announcement.
Please make sure you have the latest Excel update and verify your Office 365 subscription.
If the problem still exists, please send feedback to Microsoft or ask this community as it's the best place to get support.Hope that helps
