Kuovonne's Guide to Airtable

Share

Explore

Kuovonne's Guide to Airtable

Formatting Formulas

Operators
Operators

⁠

⁠ Tip Jar ⁠ 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

+

Add together two numeric values

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

⁠

For addition, use SUM()

For subtraction, use SUM() with -1 *

For multiplication and division, use long form with parenthesis. Put the operator on its own line

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

⁠

Share

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.