IFS, MINIFS, or MAXIFS functions returning the #NAME? error

Are you working with the IFS, MAXIFS, or MINIFS functions and can’t get them to work?

There’s one cause to 90% of all problems with the three functions.

It’s quite simple.

It’s because you don’t have an Office365 subscription.

“But I have an Excel 2016 – doesn’t that mean I have all functions?”

Unfortunately not.

If you want all functions (including IFS, MAXIFS, MINIFS, and more) you need an Office365 subscription.

Does the cell look like this after you’ve entered the function? And you’re sure you’ve spelled the function name correctly?

Then the function (IFS, MAXIFS, MINIFS) is not included in your Excel version.

Click here to purchase an Office365 subscription for only $6.99/month.

The new features that are added to Office365 every month greatly outweighs the cost of the upgrade.

Spreadsheeto highly recommends that you upgrade to Office365.

Got more questions? Click here to get in touch

Kasper Langmann, Co-founder