Thread: If Question
View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default If Question

I am trying to build a formula to place in A2 that will:

If L2 is blank I would like this formula to apply:

=IF(AND(D2<"lottery",M2<"delist"),"OK")

but if L2 is not blank, I would like this formula to apply:

=IF(AND(D2<"lottery",L2<=N1,M2<"delist");"OK")

Is there a easy way to do this ?

Thank you in advance.