Share via

IFS formula not available in office 2016

Anonymous
2019-09-17T11:17:09+00:00

Dear experts

I am a private user who has an office 2016 completely updated.

I do not have an office 265 subscription.

For some reason it does not have the IFS function.

From what I can read office 2016 should have this function.

Any help is welcome.

Amots

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-17T15:10:13+00:00

    MS documentation sucks.

    Office 2016 does not have IFS(), I have not seen any suggestion from MS that it ever will get it. Those of us with onetime payment licenses are second class customers as far as MS is concerned. They really want us to "upgrade" to 365 (pay every day for the rest of your life ...).

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-09-17T14:56:23+00:00

    You need to read the fine print, as well as between the lines.  From the IFS support page (click here):

    What that means is:   it is available as of "Excel 2016" in Office 365, but not in a standalone version of Excel until Excel 2019.

    The problem is with versioning of Excel in Office 365, IMHO.  I don't use Office 365.  But from what I've seen in this forum, Excel in Office 365 displayed version "Excel 2016" (and probably a later version now).

    Office 365 gets updated frequently.  (Not necessarily a good thing, IMHO..)

    Standalone versions of Excel get updated only when a support package is released -- and even then, it is not guaranteed to keep pace with Office 365.

    A year ago or so, I had read that MSFT promised to release a support package for standalone Excel 2016 that would include the new functions that MSFT made available in Office 365 before then.  I don't know if that ever happened.

    (I have Excel 2010, the last "good" version of Excel, IMHO.)

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-09-17T11:42:05+00:00

    Hello Amots!

    My name is Christy, an independent advisor and Microsoft user like you.

    I wish to inform you that IFS function is not included in Office 2016, rather it's present in Office 365.

    This same issue was raised by a Microsoft User in the past. I advise you go through the discussion on Microsoft community page, in order to gain more understanding of this issue.

    Here is the link; https://answers.microsoft.com/en-us/msoffice/fo...

    Let me know if you're helped by this suggestion.

    Thanks for your time.

    Christy

    Was this answer helpful?

    0 comments