Add recent Excel Windows functions to Mac version
A bunch of great new functions just went into the Windows version of Excel: https://blogs.office.com/2016/02/23/6newexcelfunctionsthatsimplifyyourformulaeditingexperience/
Please add them to the Mac version ASAP!
Hi All – with the latest update to Excel for Mac (version 16.x), there are new functions, including IFS and SWITCH, to go along with CONCAT, TEXTJOIN, MAXIFS, and MINIFS. These new functions are available to Office 365 subscribers.
Thanks – Steve K [MS Excel]
37 comments

Mark Pearson commented
I find it ridiculous that there are differences between platform versions. Surely this just pushes more and more users towards other software vendors.
This has my vote. More importantly, just keep the platform variations the same, especially for the function library. 
Mike Donahue commented
how can you have COUNTIFS, AVERAGEIFS, SUMIFS, and not IFS? Makes no sense. It seems to be there when I use the online version, but not on my Mac.
This kind of compatibility issue is ridiculous. It's 2017!
Please get all of these functions MIN, MAX, etc. added back on your next release/fix/update. 
Anonymous commented
Please add all new functions to the mac

Rick Garbacik commented
Please add all the new functions for mac. Our company has macs and p's, and the IFS function works perfectly on windows, but returns all errors on mac. The two versions must be equal.

Sean HydeMoyer commented
March 14, 2017, there is a patch for Excel on the Mac. I hold my breath, hoping against hope for switch statements. What's the changelist?
"The most relevant commands to what you're working on are at your fingertips. (Compatible with MacBook Pro with Touch Bar only.)"
Unless the most relevant commands are Switch, IFS. Sigh.

Anonymous commented
Please add all new functions to the mac

Bill commented
Not having this on a Mac is a kick in the teeth...

Anonymous commented
سلام ifs

Anonymous commented
ADD =IFS FOR EXCEL FOR MAC

Heather Frazier commented
Switch would be very helpful to me, this is the kind of thing I am currently working on using nested ifthen statements:
=IF(AA305,
IF(NOT(D305),
IF(F305="Thing1",
IF(B305="Choice1",
IF(M305<4,I$305,
IF(M305<8,I$306,
IF(M305<12,I$307,
IF(M305<16,I$308,
IF(M305<21,I$309,"Incorrect Number"))))),
IF(B305="Choice2",
IF(M305<4,I$310,
IF(M305<8,I$311,
IF(M305<12,I$312,
IF(M305<16,I$313,
IF(M305<21,I$314,"Incorrect Number"))))),
IF(B305="Choice3",
IF(M305<4,I$315,
IF(M305<8,I$316,
IF(M305<12,I$317,
IF(M305<16,I$318,
IF(M305<21,I$319,"Incorrect Number"))))),"Incorrect Choice"))),
IF(F305="Thing2",
IF(NOT(G305),
IF(NOT(H305),
IF(NOT(E305="Bit"),
IF(B305="Choice1",
IF(M305<4,"",
IF(M305<8,I$320,
IF(M305<12,I$321,
IF(M305<16,I$322,
IF(M305<21,I$323,"Incorrect Number"))))),
IF(B305="Choice2",
IF(M305<4,"",
IF(M305<8,I$324,
IF(M305<12,I$325,
IF(M305<16,I$326,
IF(M305<21,I$327,"Incorrect Number"))))),
IF(B305="Choice3",
IF(M305<4,"",
IF(M305<8,I$328,
IF(M305<12,I$329,
IF(M305<16,I$330,
IF(M305<21,I$331,
"Incorrect Number"))))),
IF(C305="OtherChoice1",
IF(M305<4,"",
IF(M305<8,I$357,
IF(M305<12,I$358,
IF(M305<16,I$359,
IF(M305<21,I$360,"Incorrect Number"))))),
IF(C305="OtherChoice2",
IF(M305<4,"",
IF(M305<8,I$361,
IF(M305<12,I$362,
IF(M305<16,I$363,
IF(M305<21,I$364,"Incorrect Number"))))),
IF(C305="OtherChoice3",
IF(M305<4,"",
IF(M305<8,I$365,
IF(M305<12,I$366,
IF(M305<16,I$367,
IF(M305<21,I$368,"Incorrect Number"))))),
IF(C305="OtherChoice4",
IF(M305<4,"",
IF(M305<8,I$369,
IF(M305<12,I$370,
IF(M305<16,I$371,
IF(M305<21,I$372,"Incorrect Number"))))),
IF(C305="OtherChoice5",
IF(M305<4,"",
IF(M305<8,I$373,
IF(M305<12,I$374,
IF(M305<16,I$375,
IF(M305<21,I$376,"Incorrect Number"))))),
"Incorrect Choice or OtherChoice")))))))),""),
IF(B305="Choice1",
IF(E305="A1",
IF(M305<4,"",
IF(M305<8,I$388,
IF(M305<12,I$395,
IF(M305<16,I$403,
IF(M305<21,"","A1 Choice1 Incorrect Number"))))),
IF(E305="A2",
IF(M305<4,"",
IF(M305<8,I$387,
IF(M305<12,I$394,
IF(M305<16,I$402,
IF(M305<21,"","A2 Choice1 Incorrect Number"))))),
IF(E305="b1",
IF(M305<4,"",
IF(M305<8,I$390,
IF(M305<12,I$397,
IF(M305<16,I$406,
IF(M305<21,"","b1 Choice1 Incorrect Number"))))),
IF(E305="b3",
IF(M305<4,"",
IF(M305<8,I$391,
IF(M305<12,I$399,
IF(M305<16,I$408,
IF(M305<21,"","b3 Choice1 Incorrect Number"))))),
IF(E305="b4",
IF(M305<12,"",
IF(M305<21,I$409,"b4 Choice1 Incorrect Number")),""))))),
IF(B305="Choice2",
IF(E305="A1",
IF(M305<4,"",
IF(M305<8,I$416,
IF(M305<12,I$423,
IF(M305<16,I$431,
IF(M305<21,"","A1 Choice2 Incorrect Number"))))),
IF(E305="A2",
IF(M305<4,"",
IF(M305<8,I$415,
IF(M305<12,I$422,
IF(M305<16,I$430,
IF(M305<21,"","A2 Choice2 Incorrect Number"))))),
IF(E305="b1",
IF(M305<4,"",
IF(M305<8,I$418,
IF(M305<12,I$425,
IF(M305<16,I$434,
IF(M305<21,"","b1 Choice2 Incorrect Number"))))),
IF(E305="b3",
IF(M305<4,"",
IF(M305<8,I$419,
IF(M305<12,I$427,
IF(M305<16,I$436,
IF(M305<21,"","b3 Choice2 Incorrect Number"))))),
IF(E305="b4",
IF(M305<12,"",
IF(M305<21,I$437,"b4 Choice2 Incorrect Number")),""))))),
IF(B305="Choice3",
IF(E305="A1",
IF(M305<4,"",
IF(M305<8,I$444,
IF(M305<12,I$451,
IF(M305<16,I$459,
IF(M305<21,"","A1 Choice3 Incorrect Number"))))),
IF(E305="A2",
IF(M305<4,"",
IF(M305<8,I$443,
IF(M305<12,I$450,
IF(M305<16,I$458,
IF(M305<21,"","A2 Choice3 Incorrect Number"))))),
... 
Sean HydeMoyer commented
Dan, any ETA on this? Just upgraded to 2016 in hopes of getting this functionality, six months on, still not available.

Sean HydeMoyer commented
This is true for the entire set of new functions available to PC Excel users: IFS, MAXIFS, MINIFS, and SWITCH functions.
The lack of compatibility is a big issue, as is the the inability to use these on Mac, full stop.
Google Sheets currently supports IFS and SWITCH, if folks need an immediate work around, and can deal with slower performance on large sheets.

Patrick Sullivan commented
Excel for PC has a new function called =IFS. This function is missing from Excel for Mac 2016. This is a problem for Excel for Mac users as spreadsheets, created with Excel for PC, that use the =IFS function, do not work on a MAC.

Jay Frantz commented
Thank you Dan!

Bryce White commented
Good news indeed!

James Spotanski (Microsoft Excel) commented
Hi Dave and Tom  we're actively working on adding these to Excel for Mac and they'll be released as soon as they're ready. My personal hope is that this will be some time in the next few months.
Thanks for the feedback!
James 
Tom Saul commented
Very embarrassing that advanced Excel spreadsheets break when I share them with Mac users, four months after new function were added in Windows. Office 365 is understood by all to be a crossplatform solution.