Multiple "OR" for single formula?

Multiple "OR" for single formula?

I have about 14 single choice options in a column that if chosen, lead to a specific Harvey ball status. I've used multiple "Or" entries, and I wonder what I'm leaving out, as it's coming back unparceable. Here's the formula:



=IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty"), IF(OR( [EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter"), IF(OR ([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half"), IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter"), IF(OR([EVAL Stage]2 = "Complete", "Full"))

Best Answers

Answers

  • edited 07/31/20

    Hello @Travis Griffin I think it might be the parentheses after each true option (see below), I believe this is closing the If statement not allowing it to continue it using the false, try putting them at the end instead



    Michael

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You are closing your IF statements too early.

    =IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty", IF(OR( [EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter", IF(OR ([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half", IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter", IF([EVAL Stage]2 = "Complete", "Full")))))

  • Thanks. I removed those, and added at the end, still getting "Unparsed"



    =IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty", IF(OR( [EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter", IF(OR ([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half", IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter", IF(OR([EVAL Stage]2 = "Complete", "Full"))))))

  • It is the last if statement, you have an "or" in there for one criteria

    Michael

  • Hot Dog. Thank you. That was it. Thanks so much for helping. So new at this.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

Sign In or Register to comment.