Forum Discussion
PapaJiOfficial
Feb 16, 2022Copper Contributor
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
PapaJiOfficial
Feb 16, 2022Copper Contributor
OliverScheurich Doesn't work , this is the result
SergeiBaklan
Feb 16, 2022Diamond Contributor
PapaJiOfficial
That could be wrong quotes, from screenshot that's not clear. Please try to open attached file and compare.
- PapaJiOfficialFeb 16, 2022Copper Contributor
SergeiBaklan Here are the screenshots, still not working
- SergeiBaklanFeb 16, 2022Diamond Contributor
PapaJiOfficial
Maybe you shall use semicolons instead of commas. Perhaps you may share sample file?- PapaJiOfficialFeb 17, 2022Copper ContributorNot working too
- allysharpFeb 16, 2022Copper ContributorIt works when I remove the " " around the numbers.