IF formula error

I have questions

Could anyone tell me what's wrong with these formula? Why is it saying incorrect argument set? This formula worked on other sheets. Thanks

=IF(OR(Status18 = "In Progress", Status19 = "In Progress", Status20 = "In Progress", Status21 = "In Progress", Status22 = "In Progress", Status23 = "In Progress", Status24= "In Progress", Status25 = "In Progress", "In Progress")

Andrée Starå

Hi @I have questions

I hope you're well and safe!

Try something like this.

=IF(OR(Status18 = "In Progress", Status19 = "In Progress", Status20 = "In Progress", Status21 = "In Progress", Status22 = "In Progress", Status23 = "In Progress", Status24= "In Progress", Status25 = "In Progress"), "In Progress")

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@I have questions

The issue is your " " characters. If you compare them to mine. Are you writing the formula in Word?

=IF(AND(Status14 = "not started", Status15 = "not started", Status16 = "not started"), "Not Started", "In Progress")

Andrée Starå

Hi @I have questions

I hope you're well and safe!

Try something like this.

=IF(OR(Status18 = "In Progress", Status19 = "In Progress", Status20 = "In Progress", Status21 = "In Progress", Status22 = "In Progress", Status23 = "In Progress", Status24= "In Progress", Status25 = "In Progress"), "In Progress")

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

I have questions

Yes, that worked. What was I missing? Thanks.

Andrée Starå

@I have questions

Excellent!

You're more than welcome!

The issue was the closing parenthesis were missing. (bolded below)

=IF(OR(Status18 = "In Progress", Status19 = "In Progress", Status20 = "In Progress", Status21 = "In Progress", Status22 = "In Progress", Status23 = "In Progress", Status24= "In Progress", Status25 = "In Progress"), "In Progress")

I have questions

Just as a follow-up. I'm having an issue with this formula too. Thoughts? Thank you.

=IF(AND(Status14 = “Not Started”, Status15 = “Not Started”, Status16 = “Not Started”), "Not Started", “In Progress”)

Andrée Starå

@I have questions

The issue is your " " characters. If you compare them to mine. Are you writing the formula in Word?

=IF(AND(Status14 = "not started", Status15 = "not started", Status16 = "not started"), "Not Started", "In Progress")

I have questions

Yes, i was. Valuable lesson. Thank you so much for your help. Happy New Year

Andrée Starå

@I have questions

I'm always happy to help!