Help

How to write an IF AND formula

Topic Labels: Formulas
1110 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ballgame168
6 - Interface Innovator
6 - Interface Innovator

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
augmented
10 - Mercury
10 - Mercury

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!