Spreadsheets - Conditional expressions

December 2016

What is a Conditional Structure?

Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets offer operators that compare values. These operators are called relational operators.

Relational Operators

Relational operators are as follows:

Operator Name Description
= equality operator Compares two operators to determine if they are equal
< strict inferiority operator Verifies that one variable is strictly lower than another
<= inferiority operator Verifies that one variable is equal to or lower than another
> strict superiority operator Verifies that one variable is strictly superior to another
>= superiority operator Verifies that one variable is equal or superior to another
<> difference operator Verifies that one variable is different from another


Related :

This document entitled « Spreadsheets - Conditional expressions » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.