How to write an IF AND formula

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.

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.

1 Like

YES!!! Thank you so much!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.