Thread
:
imbedding AND OR statements
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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"?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann