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?
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]
I updated to 16.20 mac and SWITCH no longer works, what gives
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.
And it is now broken again in 16.15
Jacek Maryan commented
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.