No switch formula in my office 2019

Copper Contributor

I cannot find the formula 'switch' in my office 2019. The last 'switch' I used becomes '_xlfn.switch' now.

5 Replies
I'm afraid that function is unavailable in Excel 2019, you need an Office 365 subscription to use SWITCH.

@Jan Karel Pieterse , I didn't check, but docs say it shall be in 2019

image.png

@Jan Karel Pieterse 

I have Excel 2019, and SWITCH is available.

Ok, my bad!
I reboot my pc and it's available now , interesting , thank u