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\).
- \(=AND(12<13;14>12;7>6)\) returns \(TRUE\).
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.
Register for free to see more content