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

 

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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

Resources