# How to nest IF statements in an Airtable formula

## At a glance

**Nesting IF**The shape is IF(condition, value_if_true, value_if_false).

**Use SWITCH for set values**SWITCH({Status}, "New", 1, "Active", 2, "Closed", 3, 0) checks one field against each value in turn.

**Join text only when a field is filled**Join 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.

## Read next

[**Airtable**](https://pushbuild.com/tools/airtable.html)[**Stop an Airtable automation running more than once**](https://pushbuild.com/guides/airtable-automation-runs-twice.html)

## 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](mailto:hello@pushbuild.com?subject=Automation%20question)

[(617) 299-8887](tel:+16172998887)

---
As of 2026-11-16. Source: https://pushbuild.com/guides/airtable-nested-if-formula.html
