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
SergeiBaklan Here are the screenshots, still not working
SergeiBaklan
Feb 16, 2022Diamond Contributor
PapaJiOfficial
Maybe you shall use semicolons instead of commas. Perhaps you may share sample file?
- PapaJiOfficialFeb 17, 2022Copper ContributorNot working too
- SergeiBaklanFeb 17, 2022Diamond Contributor
- PapaJiOfficialFeb 17, 2022Copper ContributorIt works but in the original sheet D7 is coming from a external data connection. How can I use the formula and still use external data?