This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Apparently the ifs function is supposed to be in all Office365 versions of excel. Just found that the ifs function is not supported in MAC version. Have made extensive use of this function only to find that #name? errors appear for all my collaborators using a Mac.
Now I need to revert to ugly nested "if" functions. Bloody **** Microsoft please get these versions in lockstep.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Answer accepted by question author
Hi BillieT,
The =IFS function isn't available in Excel 2016 for Mac. See Excel functions (alphabetical).
Given this situation, we suggest you submit feedback via Excel for Mac uservoice.
Thanks,
James
Hi BillieT
I'm not sure such a list would be useful. Microsoft is making rapid changes to Excel for Mac. Weekly Insider Fast builds each have different feature sets. Even if there were an up to date list today, it would be different a week from today.
It might help to know that Microsoft is making a concerted effort to bring Excel for Mac on par with Excel for Windows. I am sure they will have varying degrees of success with specific formula and feature support. If you vote and comment on features in UserVoice, Microsoft will **** how important they think particular features are and will try to implement the most requested features first.
What would be really useful is a list of what is NOT available across all platforms. Having to look through the list to find the exceptions is less useful than a pocket in undies!!! If you have a tool that is supposed to be cross platform then make it cross platform not a "almost" cross platform.
Mr. Yang, He understood and admitted in his post, he found out the Command is not available. He was asking why Microsoft can't put the same functions on both the Mac and PC version so that Mac PC user he can do real work. Please don't restate the obvious that not helpful.
_________
Disclaimer:
The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.