Gallery
Kuovonne's Guide to Airtable
Share
Explore
Formatting Formulas

# Operators

Thank Kuovonne for creating this content!
Operators are a little more challenging to format than functions because they do not inherently have starting and ending parenthesis like functions. However, we can add parenthesis around the expression anyway.
Here is an example of finding the average of three values.
(
SUM(
{value1},
{value2},
{value3}
)
/
3
)
Sometimes if the operator is very short, I tuck it at the end of the closing parenthesis of a previous function.
SUM(
{value1},
{value2},
{value3}
) / 3

### Logical operators

Operator
Description
Examples
1
>
Greater than
3 > 2 => TRUE
2
<
Less than
2 < 3 => TRUE
3
>=
Greater than or equal to
3 >= 3 => TRUE
4
<=
Less than or equal to
2 <= 2 => TRUE
5
=
Equal to
2 = 2 => TRUE
6
!=
Is not equal to
3 != 2 => TRUE
There are no rows in this table

### Numeric operators

Operator
Description
Examples
1
+
Size + 2
2
-
Subtract two numeric values
Price - 3.00
3
*
Multiply two numeric values
Price * Quantity
4
/
Divide two numeric values
Price / {Num People}
There are no rows in this table