Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|