Nov 15 2017
- last edited on
Jul 25 2018
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 them.
Please advise on how to fix this. Thanks.
Nov 15 2017 08:07 PM
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.
Aug 29 2018 05:49 AM
Aug 29 2018 09:49 AM
In general shall work
Perhaps some other reason. If you attach sample file we may check if it works on other platform.
Aug 29 2018 10:47 AM
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
Aug 30 2018 04:25 AM
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.
Aug 30 2018 07:17 AM
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.
Aug 30 2018 07:42 AM
Sep 02 2018 07:09 AM
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.
Sep 03 2018 07:04 AM
Your initial formula looks like this
What I actually did that's click on formula bar, IFs is converted to IFS and returns result.
If in addition press Enter correct formula will be populated on entire column.
Not sure why that happens, formulas are not case sensitive and column is formatted as General. But I did that on Windows desktop.
Sep 12 2018 08:48 PM
Sep 13 2018 05:03 AM
Please help me, my IFS function is not working.
why do i always get's a 4 result ?
Sep 13 2018 05:12 AM
That's separate topic, better to start new conversation in such case.
As for the function, IFS works till first TRUE condition. If E13 is -10 it's definitely less than -2.5, condition TRUE and formula returns 4/
Sep 13 2018 05:52 AM
Hey I figured it out my self after 2 hours...
I've had to switch the other way around...
start from the smallest first
and it's working
Jul 26 2019 02:16 PM
Support page https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45 says it's for Office 365 subscribers