Home

IFS Function in Excel 2016

Highlighted
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
Highlighted
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)”})
Highlighted

@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
SAVED DATE in EXCEL
ch_giannoulis in Excel on
0 Replies
Calculate time between opening hours
fresope545 in Excel on
1 Replies
Linking
Rick0302 in Excel on
2 Replies
Anyone good at custom format? Please help
Kaneszc in Excel on
1 Replies