## Syntax

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

## Description

*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.