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