Spreadsheets - Conditional expressions

January 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


Latest update on October 16, 2008 at 09:43 AM by Jeff.
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).