IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN not available in Excel for Mac with Office 365 sub.

Question

I have an Office 365 Home subscription (see info below) but do not have following to the IFS function.

According to the https://support.office.com/en-us/article/IFS-function-36329a26-37b2-467c-972b-4a39bd951d45,

"Note: This feature is not available in Excel 2016 unless you have an https://products.office.com/en-us/buy/compare-microsoft-office-products. If you are an Office 365 subscriber, https://support.office.com/en-us/article/make-sure-you-have-the-latest-version-of-Office-ee68f6cf-422f-464a-82ec-385f65391350."

Surely if I have the latest version (see info below) and the subscription I should have these functions. Why is this not the case?

Version and subscription info

damien_rosario · Answer

Hi&nbsp;Oliver Loftus&nbsp;The Microsoft support sites say that IFS is available for Office 365 for Mac.&nbsp;&nbsp;It's available for version 16.x and upwards. You are still on version 15.32 so you will need an update to get access to the feature.&nbsp;Here's the info from the source:&nbsp;https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/14450448-add-recent-excel-windows-functions-to-mac-version&nbsp;Best wishes for your IFS!&nbsp;CheersDamien