Logical arguments

The SWITCH() function can be a big time-saver when you’re working with conditional-heavy formulas (e.g. nested IF() statements). Learn more about using this function as an alternative to nested IF() statements. NOTE When writing long form...

This article covers how to evaluate arguments using AND() and OR() to streamline your team's and organization's work. Introduction  Understanding AND() and OR() Using AND() in Airtable Using AND() AND() can be used ...

Finding an empty field This content is part of a guided course that includes the BLANK() function. The BLANK() function can identify an empty value in a field or output an empty value in a formula. Typically, the BLANK() function is used wit...

This article covers how to use TRUE()  and FALSE()  functions to streamline your team's and organization's work. Introduction  TRUE() and FALSE() functions overview TRUE() and FALSE() functions NOTE TRUE() and FALSE()...

ERROR() function overview The ERROR() function is a logical function that returns an error value by outputting an #ERROR! message. ISERROR() function overview The ISERROR()  function returns "true"—represented by "1" if the expre...

This article covers how to use XOR  and NOT() functions to streamline your team's and organization's work. Introduction  Using XOR() in Airtable  Using X0R() XOR  returns a true value if an odd number of arguments ...