IF, AND, OR conditions?
 

I need M1 to answer "Y"(yes) if several logical conditions are met. I
already have this:
=IF(AND(Q155,L124,P1=""),"Y","")

but I also need M1 to answer "Y" if the following is true (i.e., it would be
an "or" statment in logics).
=IF(AND(Q160,L114,P1="Y"),"Y","")

How do I combine them?

=IF(OR(AND(Q155,L124,P1=""),AND(Q160,L114,P1=" Y"))"Y","")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MEJ" .(donotspam) wrote in message
...
I need M1 to answer "Y"(yes) if several logical conditions are met. I
already have this:
=IF(AND(Q155,L124,P1=""),"Y","")

but I also need M1 to answer "Y" if the following is true (i.e., it would
be
an "or" statment in logics).
=IF(AND(Q160,L114,P1="Y"),"Y","")

How do I combine them?

=IF(or(AND(Q155,L124,P1=""),AND(Q160,L114,P1=" Y")),,"Y","")


"MEJ" wrote:

I need M1 to answer "Y"(yes) if several logical conditions are met. I
already have this:
=IF(AND(Q155,L124,P1=""),"Y","")

but I also need M1 to answer "Y" if the following is true (i.e., it would be
an "or" statment in logics).
=IF(AND(Q160,L114,P1="Y"),"Y","")

How do I combine them?

One way:

=IF(OR(AND(Q155,L124,P1=""),AND
(Q160,L114,P1="Y")),"Y","")

HTH
Jason
Atlanta, GA


-----Original Message-----
I need M1 to answer "Y"(yes) if several logical
conditions are met. I
already have this:
=IF(AND(Q155,L124,P1=""),"Y","")

but I also need M1 to answer "Y" if the following is
true (i.e., it would be
an "or" statment in logics).
=IF(AND(Q160,L114,P1="Y"),"Y","")

How do I combine them?
.