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

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 Ishola's avatar
Fred Ishola
Copper Contributor
Aug 30, 2018
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
    • Fred Ishola's avatar
      Fred Ishola
      Copper Contributor
      Sep 02, 2018

      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.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Sep 03, 2018

        Fred,

         

        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.

         

Resources