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

[Oliver Loftus]

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

According to the Microsoft support article for the IFS function,

"Note: This feature is not available in Excel 2016 unless you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office."

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

[#2]

Hi! The last time I checked this wasn’t available in the MAC version..
Been great if anyone could confirm this though

Adam

[#3]

Hi @Oliver Loftus

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: 

https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/14450448-add-recent-excel-window...

Best wishes for your IFS!

Cheers

Damien

[#4]

Thank you very much Damien!!

[#5]

A pleasure to assist my friend. Keep up the good work!

Cheers

Damien