Home

IFS Function in Excel 2016

Highlighted
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)”})
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
Power Query Union Tablas sin Campos en Comun
Exemilenio in Excel on
0 Replies
Multiple drop down list
sure19 in Excel on
1 Replies
Insert empty row between last names
LMesi1110 in Excel on
0 Replies
Office 365 Excel Freezes
jmanderson42 in Excel on
0 Replies