The operator ET() or AND() in English is used to check if all conditions are true. Unlike the OR operator, which is true if any condition is true, the AND operator will return true only if all the specified conditions are met. If even one condition is false, the result will be false.
➡️ Display name:
AND()
➡️ Syntax:
param1
AND
param2
➡️ Example:
age
>
18
AND
ville
==
"Paris"
In this example, both conditions age > 18 and ville == "Paris" must be true for the result to be true.
- 1 condition 🟡: age > 18 is the first condition to check.
- 1 operator 🟣: AND checks if all conditions are true.
- 1 condition 🟡: ville == "Paris" is the second condition to check.
🟰 Expected result:
- If age > 18 AND ville == "Paris", the result will be true.
- If either condition is false (for example, if the age is less than 18 or the city is not Paris), the result will be false.
Before You Start
Getting Started with Formulas
The new formulas in Timetonic allow you to transform, calculate, and manipulate the information stored in your columns by combining multiple functions...
Or Continue With
Glossary View of Formulas
Quickly find the function or operator you're looking for or simply explore and learn how to use them...