Forum Discussion
IFS Function not working on newest Excel 365 and MacOS
I am trying to include a IFS Function on my Sheet but it only shows #NAME? I tried changing the ; to , but that didn't work too. I included a screenshot
=IFS(D8<$H$23,10,D8<$G$18,2,D8<$D$18,0)If i remove the " " around the numbers 10, 2 and 0 it works in my file.
OliverScheurich Doesn't work , this is the result
PapaJiOfficial
That could be wrong quotes, from screenshot that's not clear. Please try to open attached file and compare.SergeiBaklan Here are the screenshots, still not working
