Foglio elettronico - Le espressioni condizionali Folha de cálculo - as expressões condicionais Tabellenkalkulation - konditionelle 
Formatierung Tableur - Les expressions conditionnelles

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



Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Spreadsheets - Conditional expressions » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Best answers for « Spreadsheets Conditional expressions » in :
Spreadsheet - Arithmetic expressions Show Introduction Arithmetic expressions are simple expressions built with arithmetic operators and constants or references to cells. Operands are the values upon which the operator acts. There are two types of arithmetic operators: Unary operators...
Spreadsheet - Expressions Show The Concept of an Expression Expressions allow the spreadsheets to perform simple calculations using values from many cells. There are generally many types of expressions: Arithmetic expressions Conditional expressions Text expressions
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[Excel]Storage name and path of a spreadsheet Show[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
Filtering Apache logs / conditional Logging ShowFiltering Apache logs / conditional Logging Log-ins used by Apache Web server is usually very wordy, they contain all type of information (image files, style sheets, javascript, son RSS, etc.) This can be very troublesome when trying to...
Download OpenOffice ShowOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007 formats). Writer Calc ...
Download Spreadsheet Converter ShowIt is not always necessary to create a complex script in order to insert a form into a web page. The use of some line of Javascript of Spreadsheet Converter allows you to use online form. Spreadsheet Converter is a program to create a form for a...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...