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