Pushbuild

How to nest IF statements in an Airtable formula

Airtable's IF takes a condition, a value if true and a value if false. To test more than two cases, put another IF in the false slot, or use SWITCH when you are matching one field against set values.

Get a free written scope

We reply within 20 minutes with a written scope and a mockup of what we’d build.

At a glance

  1. Nesting IFThe shape is IF(condition, value_if_true, value_if_false).
  2. Use SWITCH for set valuesSWITCH({Status}, "New", 1, "Active", 2, "Closed", 3, 0) checks one field against each value in turn.
  3. Join text only when a field is filledJoin text with & or CONCATENATE().

Nesting IF

  • The shape is IF(condition, value_if_true, value_if_false).
  • For three cases: IF({Score} >= 80, "High", IF({Score} >= 50, "Medium", "Low")).
  • Each IF needs its own closing bracket. Count them at the end.
  • Combine tests with AND() and OR(), for example IF(AND({Paid}, {Shipped}), "Done", "Open").

Use SWITCH for set values

  • SWITCH({Status}, "New", 1, "Active", 2, "Closed", 3, 0) checks one field against each value in turn.
  • The last argument is the default when nothing matches.
  • It is easier to read than a long chain of IFs that all test the same field.
  1. Nesting IF
  2. Use SWITCH for set values
  3. Join text only when a field is filled
The parts of this guide, in order.

Join text only when a field is filled

  • Join text with & or CONCATENATE().
  • An empty field counts as false in IF, so {First} & IF({Middle}, " " & {Middle}) & " " & {Last} skips a blank middle name.
  • Leave out the false value and IF returns blank.

Updated 2026-11-12. General guidance, not advice for your situation; we scope each project in writing before any work starts.

Questions people ask first

Is there a limit to how many IFs I can nest?

Long chains are hard to maintain. If you are testing one field, SWITCH is the cleaner choice.

Why does my formula show #ERROR?

Usually a missing bracket, a missing comma, or a field name in braces that does not match the field exactly.

Tell us what you need built.

Tell us the process and the tools involved, or call. We reply with questions or a written scope.

hello@pushbuild.com

(617) 299-8887