imbedding AND OR statements
 

I have 2 equations that basically say:
=IF(AND(A1=A2,(OR(A3<A1))),True,False)
=IF(AND(A10=A11,(OR(A12<A13))),True,False)
These work fine on their own.
How can I combine these equations into one cell that IF the first equation
OR the second equation is true, it will return "True"?

imbedding AND OR statements
 

Try:

=IF(OR(AND(A1=A2,A1<A3),AND(A10=A11,A12<A13)),TR UE,FALSE)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Jshendel" wrote in message
...
I have 2 equations that basically say:
=IF(AND(A1=A2,(OR(A3<A1))),True,False)
=IF(AND(A10=A11,(OR(A12<A13))),True,False)
These work fine on their own.
How can I combine these equations into one cell that IF the first equation
OR the second equation is true, it will return "True"?

imbedding AND OR statements
 

If you want the True/False represented as text, try

=TEXT(OR(AND(A1=A2, A3<A1), AND(A10=A11, A12<A13)), "General")


"JMB" wrote:

AND/OR functions already return True/False. No need for an IF statement.
Try:

=OR(AND(A1=A2, A3<A1), AND(A10=A11, A12<A13))


"Jshendel" wrote:

I have 2 equations that basically say:
=IF(AND(A1=A2,(OR(A3<A1))),True,False)
=IF(AND(A10=A11,(OR(A12<A13))),True,False)
These work fine on their own.
How can I combine these equations into one cell that IF the first equation
OR the second equation is true, it will return "True"?

imbedding AND OR statements
 

AND/OR functions already return True/False. No need for an IF statement.
Try:

=OR(AND(A1=A2, A3<A1), AND(A10=A11, A12<A13))


"Jshendel" wrote:

I have 2 equations that basically say:
=IF(AND(A1=A2,(OR(A3<A1))),True,False)
=IF(AND(A10=A11,(OR(A12<A13))),True,False)
These work fine on their own.
How can I combine these equations into one cell that IF the first equation
OR the second equation is true, it will return "True"?

imbedding AND OR statements
 

This equation works.
Thanks a lot,
Josh

"Sandy Mann" wrote:

Try:

=IF(OR(AND(A1=A2,A1<A3),AND(A10=A11,A12<A13)),TR UE,FALSE)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Jshendel" wrote in message
...
I have 2 equations that basically say:
=IF(AND(A1=A2,(OR(A3<A1))),True,False)
=IF(AND(A10=A11,(OR(A12<A13))),True,False)
These work fine on their own.
How can I combine these equations into one cell that IF the first equation
OR the second equation is true, it will return "True"?