SI.CONDITIONS

The SI.CONDITIONS (IFS) function evaluates a series of conditions in order and returns the value associated with the first true condition. It replaces several nested SI with a more readable syntax. If no condition is true, it returns #N/A, unless a final VRAI (TRUE) condition acts as the default case.

Example

=SI.CONDITIONS(B2>=16;"A";B2>=12;"B";VRAI;"C")

Related concepts

The whole glossary