software

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
Hi

Use something like this:

=IF(AND(ISBLANK(M1),NOT(ISBLANK(N1)),quot;Yesquot;,quot;Noquot;)

=IF(AND(J1=quot;Yquot;,K1=quot;Yquot;,L1=quot;Yquot;),quot;Yesquot;,quot;Noquot;)

Hope this helps.
Andy.

quot;PH NEWSquot; gt; wrote in message
...
gt; Hi,
gt;
gt; How do I input this function please,
gt;
gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
gt; whatever?
gt;
gt; Thanks
gt;
gt;
IF(OR(AND(M1=quot;quot;,N1lt;gt;quot;quot;),j1=quot;yesquot;,k1=quot;yesquot;,l1=quot;yesquot; );TRUE,FALSE)

HTH
--
AP

quot;PH NEWSquot; gt; a écrit dans le message de
...
gt; Hi,
gt;
gt; How do I input this function please,
gt;
gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
whatever?
gt;
gt; Thanks
gt;
gt;
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

spllt;Andygt; wrote in message ...
gt; Hi
gt;
gt; Use something like this:
gt;
gt; =IF(AND(ISBLANK(M1),NOT(ISBLANK(N1)),quot;Yesquot;,quot;Noquot;)
gt;
gt; =IF(AND(J1=quot;Yquot;,K1=quot;Yquot;,L1=quot;Yquot;),quot;Yesquot;,quot;Noquot;)
gt;
gt; Hope this helps.
gt; Andy.
gt;
gt; quot;PH NEWSquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; How do I input this function please,
gt; gt;
gt; gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
gt; gt; whatever?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;
gt;
gt;
Thank you, perfect.
quot;Ardus Petusquot; gt; wrote in message
...
gt; IF(OR(AND(M1=quot;quot;,N1lt;gt;quot;quot;),j1=quot;yesquot;,k1=quot;yesquot;,l1=quot;yesquot; );TRUE,FALSE)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;PH NEWSquot; gt; a écrit dans le message de
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; How do I input this function please,
gt; gt;
gt; gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
gt; whatever?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;
gt;
gt;
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=quot;Ye squot;,K1=quot;Yesquot;,L1=quot;Yesquot;)),quot;Yesquot;,quot;Noquot;)

Andy.quot;PH NEWSquot; gt; wrote in message
...
gt; Cheers, but I need to be able to have it all in one cell, plus the second
gt; part of that, the j,k,l bit, I only want to be an OR, they don't all need
gt; to
gt; comply
gt;
gt; spl
gt;
gt;
gt; lt;Andygt; wrote in message ...
gt;gt; Hi
gt;gt;
gt;gt; Use something like this:
gt;gt;
gt;gt; =IF(AND(ISBLANK(M1),NOT(ISBLANK(N1)),quot;Yesquot;,quot;Noquot;)
gt;gt;
gt;gt; =IF(AND(J1=quot;Yquot;,K1=quot;Yquot;,L1=quot;Yquot;),quot;Yesquot;,quot;Noquot;)
gt;gt;
gt;gt; Hope this helps.
gt;gt; Andy.
gt;gt;
gt;gt; quot;PH NEWSquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; How do I input this function please,
gt;gt; gt;
gt;gt; gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
gt;gt; gt; whatever?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Thanks again, but I have another problem. How can I put that into a
conditional format?
lt;Andygt; wrote in message ...
gt; Sorry, misunderstood your post! I though you wanted it as 2 separate bits!
gt;
gt; Try this:
gt;
=IF(OR(AND(ISBLANK(M1),NOT(ISBLANK(N1))),OR(J1=quot;Ye squot;,K1=quot;Yesquot;,L1=quot;Yesquot;)),quot;Ye
squot;,quot;Noquot;)
gt;
gt; Andy.
gt;
gt;
gt; quot;PH NEWSquot; gt; wrote in message
gt; ...
gt; gt; Cheers, but I need to be able to have it all in one cell, plus the
second
gt; gt; part of that, the j,k,l bit, I only want to be an OR, they don't all
need
gt; gt; to
gt; gt; comply
gt; gt;
gt; gt; spl
gt; gt;
gt; gt;
gt; gt; lt;Andygt; wrote in message ...
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;gt; Use something like this:
gt; gt;gt;
gt; gt;gt; =IF(AND(ISBLANK(M1),NOT(ISBLANK(N1)),quot;Yesquot;,quot;Noquot;)
gt; gt;gt;
gt; gt;gt; =IF(AND(J1=quot;Yquot;,K1=quot;Yquot;,L1=quot;Yquot;),quot;Yesquot;,quot;Noquot;)
gt; gt;gt;
gt; gt;gt; Hope this helps.
gt; gt;gt; Andy.
gt; gt;gt;
gt; gt;gt; quot;PH NEWSquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; How do I input this function please,
gt; gt;gt; gt;
gt; gt;gt; gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
gt; gt;gt; gt; whatever?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
I've figured it out, thanks for your help

SPLlt;Andygt; wrote in message ...
gt; Sorry, misunderstood your post! I though you wanted it as 2 separate bits!
gt;
gt; Try this:
gt;
=IF(OR(AND(ISBLANK(M1),NOT(ISBLANK(N1))),OR(J1=quot;Ye squot;,K1=quot;Yesquot;,L1=quot;Yesquot;)),quot;Ye
squot;,quot;Noquot;)
gt;
gt; Andy.
gt;
gt;
gt; quot;PH NEWSquot; gt; wrote in message
gt; ...
gt; gt; Cheers, but I need to be able to have it all in one cell, plus the
second
gt; gt; part of that, the j,k,l bit, I only want to be an OR, they don't all
need
gt; gt; to
gt; gt; comply
gt; gt;
gt; gt; spl
gt; gt;
gt; gt;
gt; gt; lt;Andygt; wrote in message ...
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;gt; Use something like this:
gt; gt;gt;
gt; gt;gt; =IF(AND(ISBLANK(M1),NOT(ISBLANK(N1)),quot;Yesquot;,quot;Noquot;)
gt; gt;gt;
gt; gt;gt; =IF(AND(J1=quot;Yquot;,K1=quot;Yquot;,L1=quot;Yquot;),quot;Yesquot;,quot;Noquot;)
gt; gt;gt;
gt; gt;gt; Hope this helps.
gt; gt;gt; Andy.
gt; gt;gt;
gt; gt;gt; quot;PH NEWSquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; How do I input this function please,
gt; gt;gt; gt;
gt; gt;gt; gt; if m1 is blank and n1 is not blank or if j1=yes, k1=yes, l1=yes, =
gt; gt;gt; gt; whatever?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;