• # Logical

• ## XOR

Evaluates the given logical expressions and returns TRUE when an odd number of expressions are true, and FALSE otherwise. Syntax XOR(logic1; [logic2]...)   logic: The logical condition to evaluate. Eg., A3<5 Remarks All the text values are ignored ...
• ## TRUE

Returns the logical value TRUE, always.   Syntax   TRUE() Remarks You can also enter the value 'true' in a cell; Zoho Sheet will convert it into the logical expression TRUE by default.   Examples   Formula Result TRUE() TRUE    Possible Errors   ...
• ## SWITCH

Compares a given value or range with other given expressions, and returns a result corresponding to the first match.   Syntax   SWITCH(expression; test; value; [test1]; [value1] ...; [default]) expression: Any value or cell range to test. Eg., A2 ...
• ## OR

Returns TRUE if any of the given arguments are considered TRUE, and FALSE otherwise.   Syntax   OR(argument; [argument1]; ...) argument: The value or range containing logical values. Eg., TRUE   Remarks All the text values are ignored during ...
• ## NOT

Returns the reverse of the given logical value.   Syntax   NOT(logical_value) logical_value: The logical value to reverse. Can be TRUE or FALSE.   Remarks Zero is considered FALSE, while all other non-zero numbers are considered TRUE. Examples   ...
• ## IFS

Returns a value based on the first true condition after evaluating the multiple conditions specified. It can be used instead of multiple nested IF statements.   Syntax   IFS(test; value; [test1]; [value1]; ...) test: The first logical value or ...
• ## IFNA

Returns the result of the first value if there is no #N/A error found, and returns the specified value_if_na, otherwise.   Syntax   IFNA(value, value_if_na) value: The value to test. E.g. VLOOKUP(-0.62;A1:B7;2) value_if_na: The value to return if the ...
• ## IFERROR

Returns the result of the first value if there is no error found, and returns the specified value_if_error, otherwise.   Syntax   IFERROR(value; value_if_error) value: The value to test. Eg., A2 value_if_error: The value returned if the formula ...
• ## IF

Returns one of two given values, depending on a test condition.   Syntax   IF(test; value1; value2) test: Logical value or expression. Eg., B2>50 value1: The value that is returned by the function if test yields true. Eg., "Pass" value2: The value ...
• ## FILTER

Tests a given range and returns a filtered version of the cell range that meets the specified conditions.   Syntax   FILTER(range; condition; [condition1];...) range: The source range to be filtered. Eg., A2:E28 condition: The conditions used to ...
• ## FALSE

Always returns the logical value FALSE.   Syntax   FALSE() Remarks You can also enter the value 'false' in a cell; Zoho Sheet will convert it into the logical expression FALSE by default.  Examples   Formula Result FALSE() FALSE    Possible Errors   ...
• ## AND

Returns TRUE if all the given arguments are considered logically true, and FALSE otherwise. Considers any non-zero number to be true.   Syntax   AND(argument; [argument1]; ...) argument: The value(s) you want to test. Eg., TRUE   Remarks All the text ...