AND OR

[rhmkrmi]

Hello,

Is there a better way to write this formula?
This is a sample but it should check over 100 rows and I am going to use it for a message in an if statement in cell A2 if TRUE:

=A2=OR(AND(A10="Active",B10="Obsolete"),AND(A11="Active",B11="Obsolete"),AND(A12="Active",B12="Obsolete"),AND(A13="Active",B13="Obsolete"))

Thank you.

 

[Fluff]

Maybe
=COUNTIFS(A10:A100,"Active",B10:B100,"Obsolete")>0

 

[rhmkrmi]

Thanks.

In column B, I can have other values than "Obsolete".
For example, "Active" in A10 and "Current Year" in B10 are valid but "Active" in A11 and "Obsolete" in B11 are invalid.

If I use the COUNTIF (which I have tired before), the result will be TRUE but it actually is not because only row 11 is incorrect!

 

[RoryA]

But that's exactly the same as your existing logic. So what is it that you actually want returned?

 

[rhmkrmi]

I am sorry, I will put together a sample, you are right, I did not provide the right information!

 

[rhmkrmi]

The formula that Fluff has provided is fine, I had a misunderstanding about some of the values that I am using.
Thanks very much for your kind co-op.

 

[Fluff]

Glad we could help & thanks for the feedback