Forum Discussion
IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN not available in Excel for Mac with Office 365 sub.
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
4 Replies
- Damien_RosarioSilver Contributor
The Microsoft support sites say that IFS is available for Office 365 for Mac.
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.
Here's the info from the source:
Best wishes for your IFS!
Cheers
Damien
- Thank you very much Damien!!
- Damien_RosarioSilver Contributor
A pleasure to assist my friend. Keep up the good work!
Cheers
Damien
- Hi! The last time I checked this wasn’t available in the MAC version..
Been great if anyone could confirm this though
Adam