Forum Discussion
Solved
IFS / WENNS function
Hi, Is the IFS-function working, called WENNS in German, working on Excel 2016 Mac? It works fine on my Win labtop, and also the online version works, but not on my iMac... Truly yours, T.
Hello,
according to this article https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 (search for IFS), the function is unfortunately not available for the Mac version of Excel.
Best regards,
Mourad
Hi, this function is only available in Office 365. If you use a standalone Excel 2016 on your Mac, than this might be the reason. https://support.office.com/de-de/article/WENNS-Funktion-36329a26-37b2-467c-972b-4a39bd951d45
Well, I think I have Office 365 - at least I lock into "www . office . com / myaccount" and install the available version. Should be the newest version available!
I checked it: my account says "Office 2016 für Mac".
This is the file I get during the download:
Microsoft_Office_2016_15.32.17030901_Installer.pkg
Hello,
according to this article https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 (search for IFS), the function is unfortunately not available for the Mac version of Excel.
Best regards,
Mourad