Forum Discussion
Aaron Fitzgerald
Nov 15, 2017Copper Contributor
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...
hafizsulai
Copper Contributor
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
Nov 17, 2022MVP
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.