Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Logical
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en

Instruction: AND(logical_expression1, [logical_expression2, ...])
Language: Sheets
Context: Logical
Returns: Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more

Instruction: FALSE()
Language: Sheets
Context: Logical
Returns: Returns the logical value `FALSE`. Learn more

Instruction: IF(logical_expression, value_if_true, value_if_false)
Language: Sheets
Context: Logical
Returns: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more

Instruction: IFERROR(value, [value_if_error])
Language: Sheets
Context: Logical
Returns: Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Learn more

Instruction: IFNA(value, value_if_na)
Language: Sheets
Context: Logical
Returns: Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.

Instruction: IFS(condition1, value1, [condition2, value2], …)
Language: Sheets
Context: Logical
Returns: Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.

Instruction: LAMBDA(name, formula_expression)
Language: Sheets
Context: Logical
Returns: Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn more

Instruction: NOT(logical_expression)
Language: Sheets
Context: Logical
Returns: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more

Instruction: OR(logical_expression1, [logical_expression2, ...])
Language: Sheets
Context: Logical
Returns: Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more

Instruction: SWITCH(expression, case1, value1, [default or case2, value2], …)
Language: Sheets
Context: Logical
Returns: Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more

Instruction: TRUE()
Language: Sheets
Context: Logical
Returns: Returns the logical value `TRUE`. Learn more

Instruction: XOR(logical_expression1, [logical_expression2, ...])
Language: Sheets
Context: Logical
Returns: The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more.