Should I use IF or IF(AND....or Something Else?

Laurie Bearden

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.

Danielle Arteaga

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")

Danielle Arteaga

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")

Laurie Bearden

Thank you so much Danielle! The first formula worked perfectly. 😃