Forum Discussion
Excel 365 excel ifs
This is a photo of my license tab :
The only difference is the version... in your photo its 1711 and in mine 1705... i dont know why, i tried updating and it is still saying that it is up to date :?
Thanks for posting the version you have, it confirms your using a subscription version of Office. What's weird is you qualify for the IFS function and it should be available per the link I posted. It's not a particular new feature either, it's been around since June 2016 on the deferred channel.
The deferred channel just means you receive new features later than the monthly version - https://support.office.com/en-gb/article/Delay-receiving-feature-updates-from-Deferred-Channel-for-Office-365-ProPlus-42a703ac-618c-4cb1-bc29-3014de45692b. As far as I can work out, none of this explains this missing feature which has been around since 1602.
Anyway, you could try changing Office channel, say to the monthly channel and see if it makes a difference, check the link in this thread - How to ‘Switch Channels’ for Office 2016 ProPlus, which might help.
If it still doesn't appear and no one else can explain this, perhaps post on https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel and see if they know or open a https://support.office.com/en-gb/article/Contact-support-for-business-products-Admin-Help-32a17ca7-6fa0-4870-8a8d-e25ba4ccfd4b if you can. Hope you get to the bottom of this!