Forum Discussion
IFS Function in Excel 2016
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...
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)”})
=LOOKUP(I25,
{0,1.67,3.34,4.51},
{“Low (Level 1)”,”Medium (Level 2)”,”High (Level 3)”,”Critical (Level 4)”})