You are viewing limited content. For full access, please sign in.

Question

Question

Combine "AND" and "OR" in formula

Forms
Updated February 15, 2024
asked on February 15, 2024

I have a simple formula that returns Yes or No if the two conditions are met:

=IF(AND(EmployeeSectionHeadUsername="",EmployeeDivisionHeadUsername=""),"No", "Yes")

To this I am trying to add an OR element - OR EmpID="12345"

How can I combine AND with OR?

Numerous iterations tried, can't get it right.

Thank you.

 

0 0

Replies

replied on February 15, 2024 • Show version history

=IF(OR(EmpID="12345",AND(EmployeeSectionHeadUsername="",EmployeeDivisionHeadUsername="")),"No", "Yes")

 

THis would mean that if EmpID="12345" or the AND items are met, then the answer is No, otherwise yes.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...