Operators are the symbols and keywords used to calculate, compare, combine, and access values in AnyDB formulas.
Arithmetic
| Operator | Meaning | Example |
|---|
+ | Add | 3 + 3 |
- | Subtract | 6 - 3 |
* | Multiply | 10 * 3 |
/ | Divide | 6 / 2 |
^ | Power | 3 ^ 3 |
! | Factorial | 4! |
() | Grouping | (5 + 6) * 2 |
Comparisons
| Operator | Meaning | Example |
|---|
== | Equal | A1 == 5 |
!= | Not equal | A1 != 5 |
> | Greater than | A1 > 5 |
< | Less than | A1 < 5 |
>= | Greater or equal | A1 >= 5 |
<= | Less or equal | A1 <= 5 |
Logic and Conditions
| Operator | Meaning | Example |
|---|
and | Both conditions must be true. | A1 == 3 and B1 == 4 |
or | Either condition can be true. | A1 == 3 or B1 == 4 |
not | Reverses a condition. | not A1 == 3 |
?: | Returns one value when true and another when false. | A1 > 5 ? "Yes" : "No" |
Ranges and Access
| Operator | Meaning | Example |
|---|
: | Cell range | A1:A10 |
[] | Array index, 0-based | A1[0] |
. | Object property access | A1.name |
Related Pages