Need Help with Multiple Condition Nested Logical Functions

I am having trouble evaluating two conditions with nested logical operators to produce the output I need.

For example Condition 1 has 5 choices (A,B,C,D,E) and Condition 2 has 3 choices (a,b,c).

Breaking it down,
[Condition 1] option "A" always applies and should give "Yes" (No matter [condition 2], "A" always gives "Yes")
[Condition 2] option "c" always applies and should give "Yes" (No matter [condition 1], "c" always gives "Yes")

[Condition 1] option "D" never applies and should give "No" (No matter [condition 2], "D" always gives "No")

[Condition 1] options "C" and "B" only apply if [condition 2] is "b" (if so, the answer is "Yes")


What I need is the equivalent of:

if ((([condition 1] == A) || ([Condition 2] == c)) || (([condition 1] == B || C) && ([condition 2] == b)), "Yes", "No")

Hi,

Maybe

Formula:

Please Login or Register  to view this content.

Hmmmmm. Seems close, but it chokes at: Cond2="b"

And when it does it highlights the quotes and "b". The same check works at Cond2="c" though, so there's something slightly off here.

**** My mistake! Forgot the end " there.

Thanks again!!

Hi,

Not sure what you are saying and how it differs to the original statement of conditions.

Can you mock up a simple series of typical permutations and manually add the result you expect along with clarification notes.