Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to write an IF AND formula

Topic Labels: Formulas
242 2
Showing results for 
Search instead for 
Did you mean: 

I’m trying to create a formula where if two records are true it prints an answer. Here’s my formula: IF(AND({Role}= “Free”),{# Plans} => 5),“Cannot Add Plans”). I want it to show Cannot Add Plans if the Role = Free and the # of Plans => 5. It’s not working. Any help would be appreciated.

2 Replies 2

You need to remove the “)” after “Free” and flip the order of the operators after {# Plans} to “>=”. If the AND is still not happy, add more parens to completely separate the two boolean expressions. Good luck.

YES!!! Thank you so much!