Logical Operators
Overview
Logical operators are typically used with multiple conditions in a criteria.
Each condition returns a boolean value, and the logical operators used to connect the conditions determine the overall boolean value of the criteria.
There are 3 types of logical operators:
&& (AND) - conditions on both sides must be met.
The following truth table shows the possible outcomes when you combine two conditions with AND. The table’s left column shows the truth values of the first condition, the top row shows the truth values of the second condition, and each intersection shows the AND outcome.
AND TRUE FALSE TRUE TRUE FALSE FALSE FALSE FALSE
|| (OR) - condition on any one or both sides needs to be met
The following truth table shows the possible outcomes when you combine two conditions with OR. The table’s left column shows the truth values of the first condition, the top row shows the truth values of the second condition, and each intersection shows the OR outcome.
OR TRUE FALSE TRUE TRUE TRUE FALSE TRUE FALSE
! (NOT) - condition should not be met. Unlike AND and OR conditions, it does not connect two conditions. Instead, it negates(reverses) a single condition.
The following truth table shows the NOT outcome in the second column, based on the truth value of the condition in first column.
Condition NOT True False False True
Examples
As suggested above, there are numerous combinations of conditions and operators that are possible.
Precedence factor
- The expression within the innermost set of parentheses is processed first, followed by the next deepest, moving outward until all parentheses have been processed.
- Same logical operators in the expression will be processed left to right.
- Among logical operators, the order of the precedence is:
- NOT, AND and OR for all Zoho services.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Operators - Overview
An operator, in a programming language, is a symbol that represents an action. It tells the program to perform specific mathematical, relational or logical actions on given values to produce a final result. Operations are usually performed between ...Arithmetic Operators
In a nutshell Arithmetic operators perform mathematical operations on numeric values within test scripts. They include addition, subtraction, multiplication, division, and modulus, each applicable to specific data types. The addition operator can ...Relational Operators
In a nutshell Relational operators compare two given values and return a boolean result. They are commonly used in conditional statements within QEngine scripts and include operators such as less than, greater than, less than or equal to, greater ...Assignment Operators
In a nutshell Assignment operators in QEngine scripts assign values to variables. They come in two types: the simple assignment and compound assignment operators. The simple assignment operator assigns the value of the right operand to the variable ...Expressions
In a nutshell An expression in QEngine is a combination of constants, variables, operators, or functions that evaluates to produce a single result. Expressions are classified by the data type of the result they produce: boolean, number, decimal, ...