Share via

Excel for Mac 2016 =IFS function

Anonymous
2016-10-31T11:39:36+00:00

There  is a new function in Excel called =IFS.  Does this function work in Excel for Mac 2016.  I am getting #NAMES error messages when opening a spreadsheet, prepared on a PC using Excel 2016, on my Mac.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-06T04:35:34+00:00

    No not yet..

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-01-25T22:12:42+00:00

    Why are these new functions not available for Mac?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-01-26T16:25:10+00:00

    The place to ask your question is the official suggestion forum called UserVoice. Here's a link to the topic:

    Add =IFS Function

    Was this answer helpful?

    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-11-02T16:38:49+00:00

    If it will make you feel better you can beg to have this worksheet function added to Excel for Mac by making a feature suggestion here:

    Excel for Mac

    Was this answer helpful?

    0 comments