Spreadsheets - Conditional expressions

February 2017

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



Términos y condiciones generales de uso
Términos y condiciones generales de uso
Tableur - Les expressions conditionnelles
Tableur - Les expressions conditionnelles
Foglio elettronico - Le espressioni condizionali
Foglio elettronico - Le espressioni condizionali
Folha de cálculo - as expressões condicionais
Folha de cálculo - as expressões condicionais
This document, titled "Spreadsheets - Conditional expressions," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).