What is the IFS function? Available in Excel 365, it is a sequential multiple-condition function based on the IF function. Sequential conditions are used more often than you might think. One common use is returning the desired value based on two columns of data in Excel.
IFS Function Definition and Examples
Let’s look at Microsoft’s official definition rather than the brief explanation above.
Definition
The IFS function checks whether one or more conditions are met and returns a value corresponding to the first TRUE condition.
Function Syntax
The syntax for the Excel IFS function, which can use up to 127 conditions, is as follows.
IFS(condition1, value1, [condition2, value2], … [condition127, value127]) condition1: The condition under which value1 is returned. value1: The value returned when condition1 is TRUE. condition2: The condition under which value2 is returned. Optional argument. value2: The value returned when condition2 is TRUE. Optional argument. condition127: The condition under which value127 is returned. Optional argument. value127: The value returned when condition127 is TRUE. Optional argument. Conditions are logical expressions that must return TRUE or FALSE. If a condition is TRUE, the corresponding value is returned; otherwise, the next condition is evaluated. If all conditions are FALSE, the IFS function returns #N/A.