Thread: AND NOT AND OR
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PH NEWS
 
Posts: n/a
Default 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