Forum Discussion

Copper Contributor

Mar 29, 2017

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,

Formulas & Functions

Need Help

Deleted
Apr 11, 2017
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

6 Replies

Martin Weiß
Copper Contributor
Apr 07, 2017
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
- PlantTec Medical
  Copper Contributor
  Apr 10, 2017
  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!
  - PlantTec Medical
    Copper Contributor
    Apr 10, 2017
    I checked it: my account says "Office 2016 für Mac".