Using XOR() and NOT() functions in Airtable

  • Updated on Apr 23, 2026
  • Published on Jul 6, 2022
  • 1 minute(s) read
Prev Next

Plan Availability

All plan types

Permissions

  • Owner / Creator - Can add, delete, duplicate, rename, and customize fields

  • Editors - Sort, filter, group, hide, and copy field URL

  • Commenters / Read-only - Copy field URL

Platform(s)

Web/Browser, Mac app, and Windows app (with some additional limited support on mobile)

Using XOR() in Airtable

The XOR() function returns a “True” value when an odd number of arguments are “True.” In the example below, the XOR() function outputs a message when exactly one of the two checkboxes is checked — but not both, and not neither.

IF(
   XOR(
      {Checkbox 1}, 
      {Checkbox 2}
   ), 
   "Missing Checkmark"
)

1500000115841XOR001.jpg

Using NOT() in Airtable

The NOT function reverses the logical value of its argument — if the argument evaluates to true, NOT returns false, and vice versa. In the example below, NOT is used to flag records where a task is not yet complete:

IF(
   NOT({Complete}),
   "Still pending"
)

FAQ?

What happens when using NOT() instead of XOR()?

If NOT() is used instead of XOR(), it reverses the logical value of its argument. For example, 100 > 75 evaluates as “True”, while NOT(100 > 75) is “False.”