Should I use IF or IF(AND....or Something Else?
Good afternoon everyone.
I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or "Unparseable". The equations I tried are attached.
Best Answer

Hi, Laurie. I think your issue may be parentheses placement. Try this:
=IF(AND(Open@row = "Closed", Days@row < 30), "Yes", "No")
or try
=IF(AND(Days@row <30, Open@row = "Closed"), "Yes", "No")
Answers

Hi, Laurie. I think your issue may be parentheses placement. Try this:
=IF(AND(Open@row = "Closed", Days@row < 30), "Yes", "No")
or try
=IF(AND(Days@row <30, Open@row = "Closed"), "Yes", "No")

Thank you so much Danielle! The first formula worked perfectly. 😃
Help Article Resources
Categories
Check out the Formula Handbook template!