AND NOT AND OR

[PH NEWS]

Hi,

How do I input this function please,

if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, = whatever?

Thanks

 

[Guest]

Hi

Use something like this:

=IF(AND(ISBLANK(M1),NOT(ISBLANK(N1)),"Yes","No")

=IF(AND(J1="Y",K1="Y",L1="Y"),"Yes","No")

Hope this helps.
Andy.

 

[Ardus Petus]

IF(OR(AND(M1="",N1<>""),j1="yes",k1="yes",l1="yes");TRUE,FALSE)

HTH

 

[PH NEWS]

Cheers, but I need to be able to have it all in one cell, plus the second
part of that, the j,k,l bit, I only want to be an OR, they don't all need to
comply

spl

 

[Guest]

Sorry, misunderstood your post! I though you wanted it as 2 separate bits!

Try this:
=IF(OR(AND(ISBLANK(M1),NOT(ISBLANK(N1))),OR(J1="Yes",K1="Yes",L1="Yes")),"Yes","No")

Andy.