Logical expression for excel..

[81shelly]

How could you put this sequence in excel..

If A AND B are true return x if false return z

OR IF C>=D is true return y if false return z

Is it possible to put the whole thing on one formula?

Thanks

 

[Jonmo1]

=IF(AND(A,B),"x",IF(C>=D,"y","z"))

 

[Gerald Higgins]

Yes, but I think we'd need to understand the logic better.

How do you define that A and B are true ?

If they are both true, what if C>+D is also true ?

If the decision process is as follows, then you can write a formula for it -
If A AND B are both true, return X.
If A AND B are not both true, but C>+D is true, return Y.
Otherwise, return Z.

If this isn't the correct logic, you can still write a formula for it, but you'd need to be clear about what the logic is.

 

[Gerald Higgins]

Jonmo1 - I don't think your solution addresses the implied requirement from the OP to return z in any occurrence of A and B not being true.

 

[81shelly]

thanks thats exactly the way i wanted it..

 

[Jonmo1]

Sure it does. If Either A or B is False, it moves on to the next IF, If C>=D - if that is not true, it returns "z"

 

[Gerald Higgins]

jonmo1 - it's clearly what 81shelly wanted, but it's not what he said he wanted in the OP, which says

If A AND B are true return x if false return z

Anyway well done for correctly interpreting their request !