Home

IFS Function in Excel 2016

M_Go_Blue
Occasional Visitor

I am using the following formula in Office 365:

     =IFS(I25>=4.51,"Critical (Level 1)",I25>=3.34,"High (Level 2)",I25>=1.67,"Medium (Level 3)",I25<1.67,"Low (Level 1)")

 

It works great but when I try the same formula in Excel 2016 it adds "_xlfn." before the IFS function and the formula doesn't work.  It appears that Office 365 may be needed for the IFS function so if that is the case, how can I make this formula work in Excel 2016?

2 Replies
Use this backward compatible formula instead of IFS:
=LOOKUP(I25,
{0,1.67,3.34,4.51},
{“Low (Level 1)”,”Medium (Level 2)”,”High (Level 3)”,”Critical (Level 4)”})

@M_Go_Blue , IFS() is only for Office 365 subscribers and Excel 2019 https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45

 

Alternatives are LOOKUP() or nested IF() https://exceljet.net/formula/nested-if-function-example, IFS() was designed to replace the latest.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies