Using logical operators to compare field values in Airtable

First, check if income is greater than expenses. If income is greater than expenses, the result of the formula will be a 1 (meaning true), and if not, a 0 (meaning false).

{Income} > {Expenses}

Now, check if income is less than expenses. If income is less than expenses, the result of the formula will be a 1, and if not, a 0.

{Income} < {Expenses}

Similar to the formulas above, we can compare if income is greater than or equal to expenses (still returning a 1 or 0). The difference is most obvious in the below table when the Income and Expenses are equal—the formula returns 1.

{Income} >= {Expenses}

Now we can check the opposite, let's compare if income is less than or equal to expenses by changing the operator.

{Income} <= {Expenses}

Check if income is exactly equal to expenses.

{Income} = {Expenses}

Likewise, we can check if a value is not equal to another by adding “!” before the “=” icon.

{Income} != {Expenses}