Theory:

Operators in LibreOffice Calc:

An operator is a character or set of characters that determine the action that is to be performed or considered.
  
Logical Operators:

Logical Operators are used to comparing two or more relational expressions. These operators also always give a single value as a result True or False.
 
Some of the logical operators are,
 
AND Operator:

Logically combines two expressions. It returns a value TRUE if both or all its operands are TRUE and FALSE otherwise.
Example:
  • \(=AND(12<13;14>12;7<6)\) returns \(FALSE\).
1.jpg
  • \(=AND(12<13;14>12;7>6)\) returns \(TRUE\).
2.jpg
 
Not Operator:

Negates an expression by inverting the bit values.
 
Or Operator:

Performs a logical OR disjunction on two expressions.
 
XOR Operator:

Performs a logical Exclusive-Or combination of two expressions.