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...
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 Amairah
Aug 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.
- Fred IsholaSep 02, 2018Copper Contributor
Thanks.
I have checked and the excel sheet shows the result of the formula you inputted. I copied and passed your formula into a larger version of the excel sheet I was using, but it came up with the same #NAME error.