Forum Discussion

Copper Contributor

Sep 29, 2018

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-97...

excel

Damien_Rosario

Silver Contributor

Oct 01, 2018

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-windows-functions-to-mac-version

Best wishes for your IFS!

Cheers

Damien

adam deltinger
MVP
Oct 01, 2018
Thank you very much Damien!!
- Damien_Rosario
  Silver Contributor
  Oct 02, 2018
  A pleasure to assist my friend. Keep up the good work!
  
  Cheers
  Damien