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