Skip to main content
Solved

Can't Get Nested IF AND Statements to Work

E

Hello Airtable community!

I inherited a pretty robust Airtable system from a predecessor and have been working to revamp it, but my formula skills are not as good as the person who came before me, and I've been struggling to get IF AND statements to work. The logic seems sound, but they keep returning empty cells.

One of the ones I'm struggling with concerns a formula that should return 1 of 2 options if a cell has a specific entry. I can get a single IF statement to return the correct result, but as soon as I try to include an AND, it fails. Here's what I have so far:

In my table, the formula field is 'Ship From' with the two options being 'Direct from Printer' or 'X Distributor'. I want the formula to return 'Direct from Printer' if another field - 'Role' - is one of 3 options: Marketing/Sales, Licensor, or Editor in Chief. All other Roles should return 'X Distributor.'

So I put in:

 
IF(AND({Role}="Marketing/Sales",
IF(AND({Role}="Licensor",
IF(AND({Role}="Editor in Chief","Printer","X Distributor"))))
 
Should it be an OR statement? Please tell me what I'm missing.

Best answer by kuovonne

The word order in Airtable formula language is different from the word order in English.

IF(
OR(
{Role}="Marketing/Sales",
{Role}="Licensor",
{Role}="Editor in Chief"
),
"Printer",
"X Distributor"
)
View original
Did this topic help you find an answer to your question?

3 replies

kuovonne
Forum|alt.badge.img+17
  • kuovonne
  • Brainy
  • 5987 replies
  • Answer
  • February 25, 2025

The word order in Airtable formula language is different from the word order in English.

IF(
OR(
{Role}="Marketing/Sales",
{Role}="Licensor",
{Role}="Editor in Chief"
),
"Printer",
"X Distributor"
)
E
1 person likes this
  • E
    emdeesee
M
  • Marvel
  • Participating Frequently
  • 11 replies
  • February 25, 2025

You're very close, but the issue is in how you're using the AND function. Instead of AND, you should use OR because you want to check if {Role} is any of the three options, not all at once. Here’s the correct formula:

IF(OR({Role}="Marketing/Sales", {Role}="Licensor", {Role}="Editor in Chief"), "Direct from Printer", "X Distributor")

This means:

  • If {Role} is either "Marketing/Sales," "Licensor," or "Editor in Chief," it will return "Direct from Printer."
  • If it's anything else, it will return "X Distributor."

Try this, and let me know if you need more help! 😊

E
  • emdeesee
  • Author
  • New Participant
  • 1 reply
  • February 26, 2025

Thank you both, I got it!

Reply


Most helpful members this week

Terms & Conditions