Mar 21 2019 07:01 AM
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?
Mar 21 2019 12:12 PM
Mar 21 2019 01:29 PM
@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.