Returns a value you specify if a formula evaluates to an error; otherwise returns the formula's result
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
Evaluates an expression against a list of values and returns the result corresponding to the first matching value