AND NOT AND OR
 

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

AND NOT AND OR
 

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.

"PH NEWS" wrote in message
...
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

AND NOT AND OR
 

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

HTH
--
AP

"PH NEWS" a écrit dans le message de
...
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

AND NOT AND OR
 

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


<Andy wrote in message ...
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.

"PH NEWS" wrote in message
...
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

AND NOT AND OR
 

Thank you, perfect.
"Ardus Petus" wrote in message
...
IF(OR(AND(M1="",N1<""),j1="yes",k1="yes",l1="yes" );TRUE,FALSE)

HTH
--
AP

"PH NEWS" a écrit dans le message de
...
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

AND NOT AND OR
 

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="Ye s",K1="Yes",L1="Yes")),"Yes","No")

Andy.


"PH NEWS" wrote in message
...
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


<Andy wrote in message ...
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.

"PH NEWS" wrote in message
...
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

AND NOT AND OR
 

Thanks again, but I have another problem. How can I put that into a
conditional format?
<Andy wrote in message ...
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="Ye s",K1="Yes",L1="Yes")),"Ye
s","No")

Andy.


"PH NEWS" wrote in message
...
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


<Andy wrote in message ...
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.

"PH NEWS" wrote in message
...
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

AND NOT AND OR
 

I've figured it out, thanks for your help

SPL


<Andy wrote in message ...
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="Ye s",K1="Yes",L1="Yes")),"Ye
s","No")

Andy.


"PH NEWS" wrote in message
...
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


<Andy wrote in message ...
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.

"PH NEWS" wrote in message
...
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