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.