Operators are special symbols like

and **+**

that act on one or two values to return a new value. Quickbase evaluates operators in a specific order, called operator precedence. *****

## Operator precedence

Quickbase evaluates certain operators before it acts on others.

For example,

- * has higher precedence than +.
- The expression
**3+4*2**evaluates as:- 4*2 = 8
- 8+3 = 11

### Types of operators

**Unary operators**

- Act on a single value. See list of unary operators.
- Evaluate right to left when there are multiple of the same precedence next to each other

**Binary operators**

- Act on two values. See list of binary operators
- Evaluate left to right when there are multiple of the same precedence next to each other

### Operator precedence table

The following table lists operators from highest precedence to lowest precedence:

Precedence Level | Operator | Evaluation Order in Expressions |
---|---|---|

1 (highest) | unary +, unary -, not | Right to left |

2 | ^ | Left to right |

3 | *, / | Left to right |

4 | binary +, binary -, & | Left to right |

5 | <, >, <=, >= | Left to right |

6 | =, <>, != | Left to right |

7 | and | Left to right |

8 (lowest) | or | Left to right |

### Manually control operator precedence

Enclose portions of your formula in parentheses to manually control operator precedence.

- Quickbase evaluates operators within parentheses first
- Then uses the resulting calculation when it moves on to the rest of the formula