The SWITCH function

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 may be returned.

LogicalMatthew Di MinnoApril 7, 2020Comment

The OR function

Returns TRUE if any argument is TRUE

LogicalMatthew Di MinnoMarch 23, 2020Comment

The NOT function

Reverses the logic of its argument

LogicalMatthew Di MinnoMarch 20, 2020Comment

The IFS function

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

LogicalMatthew Di MinnoMarch 4, 2020Comment

The IFERROR function

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

LogicalMatthew Di MinnoMarch 3, 2020Comment

The IF function

Specifies a logical test to perform

LogicalMatthew Di MinnoMarch 2, 2020Comment

The AND function

Returns TRUE if all of its arguments are TRUE

LogicalMatthew Di MinnoFebruary 9, 2020Comment