Logic

b0: logical value

b1: logical value

AND calculates the logical conjunction of its arguments b0,b1,...

If an argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is strict: if any argument is an error, the result will be the first such error.

This function is Excel compatible.

OR, NOT, IF.

FALSE returns the value FALSE.

This function is Excel compatible.

TRUE, IF.

cond: condition

trueval: value to use if condition is true

falseval: value to use if condition is false

This function first evaluates the condition. If the result is true, it will then evaluate and return the second argument. Otherwise, it will evaluate and return the last argument.

AND, OR, XOR, NOT, IFERROR.

x: value to test for error

y: alternate value

This function returns the first value, unless that is an error, in which case it returns the second.

IF, ISERROR.

x: value to test for #N/A error

y: alternate value

This function returns the first value, unless that is #N/A, in which case it returns the second.

IF, ISERROR.

cond1: condition

value1: value if condition1 is true

cond2: condition

value2: value if condition2 is true

This function returns the value after the first true conditional. If no conditional is true, #VALUE! is returned.

IF.

b: logical value

NOT calculates the logical negation of its argument.

If the argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored.

This function is Excel compatible.

AND, OR, IF.

b0: logical value

b1: logical value

OR calculates the logical disjunction of its arguments b0,b1,...

If an argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is strict: if any argument is an error, the result will be the first such error.

This function is Excel compatible.

AND, XOR, NOT, IF.

ref: value

choice1: first choice value

value1: first result value

choice2: second choice value

value2: second result value

This function compares the reference value, ref, against the choice values, choice1 etc., and returns the corresponding result value when it finds a match. The choices may be followed by a default value to use. If there are no choices that match and no default value, #N/A is return.

IF, IFS.

TRUE returns the value TRUE.

This function is Excel compatible.

FALSE, IF.

b0: logical value

b1: logical value

XOR calculates the logical exclusive disjunction of its arguments b0,b1,...

If an argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is strict: if any argument is an error, the result will be the first such error.

OR, AND, NOT, IF.