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
SergeiBaklan
Feb 17, 2022Diamond Contributor
That doesn't matter how the value appeared in the cell, manually entered, by formula or that's linked value. All shall work. The only be sure be sure the linked value is number, not text, otherwise you shall work with it as with text.
PapaJiOfficial
Feb 17, 2022Copper Contributor
It still doesn't work, I tried
out every possibility
out every possibility