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