2,155
edits
Changes
→Logical Expressions
* '''And (&&)''': Performs the logical operation ''AND'' between two boolean values. The two operands must be ''true'' for the result of the operation to be ''true''. Represented by the ''AND'' operator (&&). The expression syntax is ''<expression> && <expression>''. '''Examples''': IF((Gross Sales > '0') && (Seller == 'John Snow');'Sold';'Not Sold'), IF((City!="#null") && (Date<DAY_FROM_TODAY(0));1;0);
* '''Not Or (!||)''': Performs the denial logical operation for a ''OR'' between two boolean valuevalues. If One of the operand are two operands must be ''true'' for the ''NOT'' convert it result of the operation to be ''falsetrue'' (and the other way around). Represented by the ''NOTOR'' operator (!||). The expression syntax is ''! <expression> || <expression>''. '''Examples''': IF(!BETWEEN("Date", Gross Sales > '01/01/20130', ) || (Sold == '31/12/2013true');'Not 2013Sold';'2013Not Sold')., IF((City!="#null") || (Date<DAY_FROM_TODAY(0));1;0);
* '''Not (!)''': Performs the denial logical operation for a boolean value. If the operand are ''true'' the ''NOT'' convert it to ''false'' (and the other way around). Represented by the ''NOT'' operator (!). The expression syntax is ''! <expression>''. '''Examples''': IF(!BETWEEN("Date", '01/01/2013', '31/12/2013');'Not 2013';'2013').
== Auxiliary Functions ==