If Or Statement

Aaron Surber

Hi All - I've been going round and round with this formula and getting the Unparseable error. My guess is that it is really simple, but I'm not finding it. I want invoices that are current, paid or less than 30 days old to return green. I want invoices over 60 days old to return red. Anything else to return yellow. My formula is as follows:

=IF(OR(Days Outstanding@row <30, [Sales Stage]@row = "Current", [Sales Stage]@row = "Paid", “Green”, IF(Days Outstanding@row >= 60, “Red”, “Yellow”))

Any help you can provide would be great. Thanks.

mimcclain

Hi Aaron,
I put this in our Ai Get Help feature which can help you fix your formulas when you get stuck and this is what it said:

Here's the corrected formula:

plaintext1=IF(OR(Days Outstanding@row < 30, [Sales Stage]@row = "Current", [Sales Stage]@row = "Paid"), "Green", IF(Days Outstanding@row >= 60, "Red", "Yellow"))2

Explanation:

• Added a closing parenthesis for the OR function.
• Changed curly quotation marks to standard straight quotes for the text values "Green," "Red," and "Yellow."

Hope this helps!

Aaron Surber

Hi and thanks for the quick response. Unfortunately, the AI function still returns an unparseable error.