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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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] (Admin, Office.com) 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]

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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