Forum Discussion
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...
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.1
I am using office 365 (through my office MAC laptop) and also having the same error. I am using Excel version 16.16.1
In general shall work
Perhaps some other reason. If you attach sample file we may check if it works on other platform.
IFS does not work in my Excel 2016 even though the help page says it does. It is not listed in the functions.
Support page https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45 says it's for Office 365 subscribers
- Hi sir,
can you help me with this ifs formula error,
=ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")
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.
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.
- Hello 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
