# Logical Expressions

**Logical** expressions are used to evaluate conditions and make decisions within your application. This category includes functions for comparison, boolean operations (such as AND, OR, NOT), and conditional statements.&#x20;

<table data-full-width="true"><thead><tr><th width="155">Expression</th><th width="401">Description</th><th width="174">Operands Number</th><th width="168">Operands Type</th><th>Result Type</th></tr></thead><tbody><tr><td><strong>Boolean</strong></td><td>Represents a logical value that can be either true or false.</td><td>1</td><td>Boolean Constant</td><td>Boolean</td></tr><tr><td><strong>And</strong></td><td>Returns true if both conditions are true; otherwise, returns false.</td><td>>=2</td><td>Boolean</td><td>Whole Number</td></tr><tr><td><strong>Or</strong></td><td>Returns true if at least one of the conditions is true; otherwise, returns false.</td><td>>=2</td><td>Boolean</td><td>Whole Number List</td></tr><tr><td><strong>And Also</strong></td><td>Performs a logical AND operation on its operands only if the first operand evaluates to true.</td><td>>=2</td><td>Boolean</td><td>Boolean</td></tr><tr><td><strong>Or Else</strong></td><td>Performs a logical OR operation on its operands only if the first operand evaluates to false.</td><td>>=2</td><td>Boolean</td><td>Boolean</td></tr><tr><td><strong>Is Not Null</strong></td><td>Checks if a value is not null.</td><td>1</td><td>Any</td><td>Boolean</td></tr><tr><td><strong>Is Null</strong></td><td>Checks if a value is null.</td><td>1</td><td>Any</td><td>Boolean</td></tr><tr><td><strong>Text Is Null</strong></td><td>Checks if a text string is null.</td><td>1</td><td>Text</td><td>Boolean</td></tr><tr><td><strong>Text Is Not Null</strong></td><td>Checks if a text string is not null.</td><td>1</td><td>Text</td><td>Boolean</td></tr><tr><td><strong>Is Equal to</strong></td><td>Compares two values to determine if they are equal.</td><td>2</td><td><p>Decimal, Date or  Text</p><p><em>Both Operands should be of the same time</em></p></td><td>Boolean</td></tr><tr><td><strong>Is Not Equal to</strong></td><td>Compares two values to determine if they are not equal.</td><td>2</td><td><p>Decimal, Date or Text</p><p><em>Both Operands should be of the same time</em></p></td><td>Boolean</td></tr><tr><td><strong>Is Greater Than</strong></td><td>Compares two values to determine if one is greater than the other.</td><td>2</td><td><p>Decimal or Date</p><p><em>Both Operands should be of the same time</em></p></td><td>Boolean</td></tr><tr><td><strong>Is Greater Than or Equal to</strong></td><td>Compares two values to determine if one is greater than or equal to the other.</td><td>2</td><td><p>Decimal or Date</p><p><em>Both Operands should be of the same time</em></p></td><td>Boolean</td></tr><tr><td><strong>Is Less Than</strong></td><td>Compares two values to determine if one is less than the other.</td><td>2</td><td><p>Decimal or Date</p><p><em>Both Operands should be of the same time</em></p></td><td>Boolean</td></tr><tr><td><strong>Is Less Than or Equal to</strong></td><td>Compares two values to determine if one is less than or equal to the other.</td><td>2</td><td><p>Decimal or Date</p><p><em>Both Operands should be of the same time</em></p></td><td>Boolean</td></tr><tr><td><strong>Contains Item</strong></td><td>Checks if a collection contains a specified item.</td><td>2</td><td><p>1st  is a List</p><p>2nd same type as list<br><br></p></td><td>Boolean</td></tr><tr><td><strong>Inclusive Between</strong></td><td>Determines if a value falls within a specified range, inclusive of the boundary values.</td><td>3</td><td><p>Whole Number/Decimal</p><p><em>1st operand is the argument, and the two others are the min and max ranges</em></p></td><td>Boolean</td></tr><tr><td><strong>Exclusive Between</strong></td><td>Determines if a value falls within a specified range, exclusive of the boundary values.</td><td>3</td><td><p>Whole Number/Decimal</p><p><em>1st operand is the argument, and the two others are the min and max ranges</em></p></td><td>Boolean</td></tr><tr><td><strong>Min Range Inclusive Between</strong></td><td>Determines if a value falls within a specified range, including the minimum boundary value.</td><td>3</td><td><p>Whole Number/Decimal</p><p><em>1st operand is the argument, and the two others are the min and max ranges</em></p></td><td>Boolean</td></tr><tr><td>Max Range Inclusive Between</td><td>Determines if a value falls within a specified range, including the maximum boundary value.</td><td>3</td><td><p>Whole Number/Decimal</p><p><em>1st operand is the argument, and the two others are the min and max ranges</em></p></td><td>Boolean</td></tr><tr><td><strong>If</strong></td><td>Executes a block of expressions based on whether a specified condition is true or false.</td><td>3</td><td><p>1st Boolean</p><p>2nd and 3rd any</p></td><td>True/False Branch types</td></tr><tr><td><strong>Is Empty</strong></td><td>Checks if a collection of values is empty.</td><td>1</td><td>List</td><td>Boolean</td></tr></tbody></table>
