PDF chapter test TRY NOW
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](https://resources.cdn.yaclass.in/878e555c-06f1-410b-b7e3-5f7b6efc0ec3/1w300.jpg)
- \(=AND(12<13;14>12;7>6)\) returns \(TRUE\).
![2.jpg](https://resources.cdn.yaclass.in/45d543be-48a0-41b5-961b-18b20e29477f/2w300.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.