Applies To: Excel 2016 for Windows, Excel 2016 for Mac
What is IFS?
IFS is a logical function in Excel. The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and it is much easier to read with multiple conditions.
= IFS(logical_test1, Value1 [logical_test2, Value2] …, [logical_test127, Value127])
Logical_test1 – First logical test. It is a required argument and is the condition that is used by Excel to evaluate whether it is TRUE or FALSE.
Value1 – Result when logical_test1 is true. If required, we can keep it empty.
The rest of the logical_test and Value arguments are optional; the function allows the user to put 127 logical_test arguments using the IFS function.
How to use IFS?
IFS function Grades example. Formula in cell B2 is =IFS(A2>89,"A",A2>79,"B",A2>69,"C",A2>59,"D",TRUE,"F")
IF(A2 is Greater Than 89, then return a "A",
IF A2 is Greater Than 79, then return a "B",
IF A2 is Greater Than 69, then return a "C",
IF A2 is Greater Than 59, then return a "D"
and 58 doen't meet any of the other conditions return an "F")