Written by The XOR function computes an exclusive or between two numbers, yielding a 1 when they differ and a 0 when they are the same.
Produces the logical value of `TRUE`.
Evaluates an expression against a series of cases and returns the value of the first case that matches, along with an optional default if no cases are met.
Returns true if at least one of the provided arguments is logically true; returns false only if all arguments are logically false.
Returns the inverse of a logical value; `NOT(TRUE)` results in `FALSE`, while `NOT(FALSE)` gives `TRUE`.
Assigns a name with the results of the value_expression and returns the outcome of the formula_expression. The formula_expression can reference the names defined within the LET function’s scope. Importantly, the value_expressions are evaluated just once, even if referenced multiple times in subsequent value_expressions or in the formula_expression.
Establishes and returns a custom function using defined names and a formula_expression that incorporates them. You can invoke the resultant function with as many arguments as specified in the names.
Assesses various conditions and returns a corresponding value for the first condition that evaluates to true.
Assesses a given value, returning a defined result if that value is an #N/A error.
Returns the first argument when it is not an error; otherwise, it yields the second argument if provided, or a blank if the second is not available.