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...
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.