IFERROR Function
Returns the second argument if the first argument contains an error. Returns the first argument if no error is found.
IF Function
Returns second argument if the condition is met else it returns third argument.
NOT Function
Returns TRUE if the argument is FALSE and FALSE if the argument is TRUE.
XOR Function
Returns TRUE if an odd number of arguments are TRUE.
OR Function
Returns TRUE if at least one argument is TRUE.
AND Function
Returns TRUE if all arguments are TRUE.