Conditional statements

NAME	DESCRIPTION
IF	Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
IFNA	Returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula
SWITCH	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.
FILTERIF	Returns the list of items that match the given condition