Feedback by UserVoice

How can we improve Excel for Mac?

Please give Mac users of Office 365 Excel the SWITCH function too

I have an Office 365 subscription and it's infuriating that the SWITCH command which I can use on my PC will not work on my MacBook version (OF THE SAME SOFTWARE FROM THE SAME SUBSCRIPTION!).....Isn't it time you synchronised all versions of the software to give the same functionality to all users regardless of platform?

12 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Dave shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminExcel Team [MSFT] (Product Owner, responded  · 

The SWITCH function (and also the IFS function) is now available in Excel for Mac version 16.x for O365 subscribers. To update, go to the Help menu and choose Check for Updates.

Thanks – Steve K [MS Excel]


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • eric commented  ·   ·  Flag as inappropriate

    I updated to 16.20 mac and SWITCH no longer works, what gives

  • Anonymous commented  ·   ·  Flag as inappropriate

    I have the version that includes switch, and when I went to share my (switch-using) docs with coworkers, it did not work for them despite having newer versions of excel than I do.

  • Jacek Maryan commented  ·   ·  Flag as inappropriate

    My Office 365 for Mac does not include the SWITCH function. Either my Mac Office 365 is fully compatible with my PC Office 365 or I am cancelling my subscription and uninstalling.

Feedback and Knowledge Base