Forum Discussion
Aaron Fitzgerald
Nov 15, 2017Copper Contributor
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...
SergeiBaklan
Aug 29, 2018MVP
In general shall work
Perhaps some other reason. If you attach sample file we may check if it works on other platform.
Fred Ishola
Aug 30, 2018Copper Contributor
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.
- Haytham AmairahAug 30, 2018Silver Contributor
Fred,
It seems that you have no Office 365 subscription as I don't see anything in About Excel Form indicates that you have an Office 365 subscription.
- Fred IsholaAug 30, 2018Copper ContributorHello Haytham,
Thanks.
I work for an S&P 500 company, and our Office 365 subscription comes included in our devices(including SharePoint online). When working remotely I check my work mails/outlook through office 365 online. My Excel comes as part of the office subscription- SergeiBaklanAug 30, 2018MVP
Hi Fred,
Could you please check if attached works on your computer.