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.
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.