G
Guest
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.
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.