Conditional statements
Last updated
Last updated
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