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.

Not really tested but since you want the same answer this might work

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


Regards,

Peo Sjoblom

"carl" wrote:

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.

Hi
one way:
=IF(AND(D2<"lottery",M2<"delist"),IF(OR(L2="",AN D(L2<"",L2<=N1)),"OK","not
defined"),"not defined")

--
Regards
Frank Kabel
Frankfurt, Germany
"carl" schrieb im Newsbeitrag
...
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.