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.
Relational Operators:
Relational operators are used to comparing two values. They form relational expressions. These operators always give a single value as a result: True or False.
Operator | Function | Usage |
\(=\) | Equal to | \(B2 = B3\) |
\(<>\) | Inequality (Not equal to) | \(C2<>C3\) |
\(>\) | Greater than | \(D2>D3\) |
\(<\) | Less than | \(E2<E3\) |
\(>=\) | Greater than or Equal to | \(F2>=F3\) |
\(<=\) | Less than or Equal to | \(G2<=G3\) |
Example:
Equal to:
![1.png](https://resources.cdn.yaclass.in/3390811a-0744-4a0f-87ce-4783378baf51/1w300.png)
Not equal to:
![2.jpg](https://resources.cdn.yaclass.in/4edb016f-250e-48fc-8e1b-dd7c4249d895/2w300.jpg)
Greater than:
![3.jpg](https://resources.cdn.yaclass.in/f316f116-22d3-4d46-ad9d-fdbf34c1490a/3w300.jpg)
Less than:
![4.jpg](https://resources.cdn.yaclass.in/64013db9-89cb-4ddc-843b-881efc1687d5/4w300.jpg)
Greater than or Equal to:
![5.jpg](https://resources.cdn.yaclass.in/8d4636ab-c641-4c25-aec1-4d27ce29236a/5w300.jpg)
Less than or Equal to:
![6.jpg](https://resources.cdn.yaclass.in/eea745f9-dc94-4340-9da5-77aede5e1e54/6w300.jpg)