 11 Dec 2023
 1 Minute to read
 Print
 DarkLight
 PDF
Using logical operators to compare field values in Airtable
 Updated on 11 Dec 2023
 1 Minute to read
 Print
 DarkLight
 PDF
Logical operators allow you to compare values in one field to other fields. See the operators listed below for an introduction to their symbols and usage.
All plans types  
Platform(s)  Web/Browser, Mac app, and Windows app 
Related reading 
Operators in Airtable
Airtable operators
Operator  Symbol  Use  Example  

Greater than 

 Compare if one number is greater than another 


Less than 

 Compare if one number is less than another 


Greater than or equal to 

 Compare if one number is greater than or equal to another 


Less than or equal to 

 Compare if one number is less than or equal to another 


Equal to 

 Compare if one value is equal to another value 


Does not equal 

 Check if one value is not equal to another value 


Greater and less than operators
NOTE
For the following examples, assume that you want to compare income against expenses on a weekly basis.
Greater than
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}
Less than
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}
Greater, less than, and equal to operators
Greater than or equal to
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}
Less than or equal to
Now we can check the opposite, let's compare if income is less than or equal to expenses by changing the operator.
{Income} <= {Expenses}
Equal and does not equal to operators
Equal
Check if income is exactly equal to expenses.
{Income} = {Expenses}
Does not equal
Likewise, we can check if a value is not equal to another by adding “!” before the “=” icon.
{Income} != {Expenses}