IFS Function

The IFS returns the value based on multiple True or False conditions.
Refer to the Inserting Conditional Formulas page for other ways to create conditional formulas.

This function can return two different values depending on whether the logical test evaluates to True or False
SS

Logical Operators

Multiple True or False Conditions

The IFS (Added in 2019) returns a value based on multiple True or False conditions.

Nesting

Multiple true or false conditions can also be achieved by nesting IF functions.
Using nested IF functions is a common way to conditionally test, although try to avoid seven if possible as it requires a lot of effort to understand.
If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out.
You can nest up to 64 IF Functions.
If you need to nest more than 7 times it is strongly recommended that you split the formula into separate pieces.
Use a named ranges to define your smaller bits. IF(OneToSix,OneToSix,SevenToThirteen), whereOneToSix has 6 nested IF statements and SevenToThirteen has another 7.

Array Formula

This function can return an array formula.