IFS(is-this-true?, then-do-this[, is-this-true?, then-do-this]...)


IFS() evaluates each condition (is-this-true?, a Yes/No value) of a series in order until one is TRUE, then evaluates the corresponding result expression (then-do-this) and returns the result. Each result expression should produce a value of the same type.

Return Value

The result of evaluating the then-do-this expression that corresponds to the first is-this-true? condition that is TRUE. If no is-this-true? is TRUE, blank is returned.

Did this answer your question?