...
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
Equality (==)
Inequality (!=)
Less than (<)
Greater than (>)
Less than or equal to (<=)
Greater than or equal to (>=)
Logical AND (&&)
Logical OR (||) (jump to example)
Logical NOT (!)
Ternary Operator ( ? )
Operands
Operands are the values or expressions that operators act upon. They can be numbers, strings, dates, or references to other cells or fields.
Functions
Functions are built-in routines that perform specific tasks, such as calculations, data manipulation, and text processing. They can take arguments (inputs) and return values (outputs).
Formula Building Techniques
...
Question | Formula | ||||||||
Display when answer = Blue (The text selection is case sensitive) |
| ||||||||
Display when answer > 10 (num function converts the value to a number) |
| ||||||||
Display when answer = Yes |
| ||||||||
Display when answer = A Or D
|
| ||||||||
Display when Question 1 = M OR Question 2 = X |
| ||||||||
Display when sum of Question 1 and Question 2 > 100 (num function converts the value to a number) |
| ||||||||
Display when the count of items >= 3 |
| ||||||||
Display when the text contains the word “show” (toLowerCase converts the text to all lower case and then in this example compares to the lower case value “show”) |
| ||||||||
Display when checkbox is checked |
| ||||||||
Display when checkbox is unchecked |
|
Advance Conditional Formula Examples
...