Logical arguments

SWITCH() is one of Airtable’s most recent additions to the formula field, and it can be a big time-saver when you’re working with conditional-heavy formulas (e.g. nested IF statements). To demonstrate the difference between using SWITCH() ...

In this article, we'll primarily be working with two very similar formulas: AND() and OR() . This article is part of a guided course which you can view here. Working with AND() AND () can be used on it's own as a standalone function, and...

The BLANK()  function can be used to identify a blank, or empty, value in a field. It can also be used to output an empty value (nothing) in a formula. Typically, BLANK()  is used within an IF statement. This article is part of a guided course w...

When creating conditional formulas, TRUE() and FALSE()  functions assist in yielding specific true and false results when you need to explicitly provide that type of output. This article discusses how these functions work and common ways to use th...

Formulas provide so many possibilities that, by nature, some of those possibilities will result in an error. Fortunately, with the help of logical functions, you can catch those errors and present something more useful in their place. In this articl...

In this article, we'll walk through how to use the XOR  and NOT functions. This article is part of a guided course which you can view here. XOR() XOR  returns a true value if an odd number of arguments are true. As an example, let's say th...