Conditional statements


Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

Returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value is returned.

Returns the list of items that match the given condition

Last updated