Forum Discussion

Aaron Fitzgerald's avatar
Aaron Fitzgerald
Copper Contributor
Nov 15, 2017

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...
Excel Desktop
Formulas & Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Nov 16, 2017

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:

IFS Function

 

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.

 

Fred Ishola's avatar
Fred Ishola
Copper Contributor
Aug 29, 2018
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
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 29, 2018

    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

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 29, 2018

    In general shall work

    Perhaps some other reason. If you attach sample file we may check if it works on other platform.

    • ApolloJFK's avatar
      ApolloJFK
      Copper Contributor
      Jul 26, 2019

      IFS does not work in my Excel 2016 even though the help page says it does.  It is not listed in the functions.

    • Fred Ishola's avatar
      Fred Ishola
      Copper Contributor
      Aug 30, 2018

      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's avatar
        Haytham Amairah
        Silver Contributor
        Aug 30, 2018

        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.

Resources