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.
How to write an IF AND formula
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.
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.