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
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
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 17, 2022

    hafizsulai 

    That's strange, IFS() shall work on 365. You always may use set of IF() instead, google "excel nested if" - lot of samples and posts.

  • hafizsulai's avatar
    hafizsulai
    Copper Contributor
    Nov 17, 2022

    SergeiBaklan HI, tried Case changing also and i am a 365 user still it's not working, And i am a beginner in excel can you suggest any other formula to get the value withthe alternate function

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    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.

     

  • 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.

Resources