IF/AND/OR Help

[dennis.davis]

I am having an awful time trying to figure this out, been searching the
newsgroups like crazy and trying many different configurations.

Ok here's what I have.

In cell L2 the value can be 0,"","TBD". The "" and 0 may be the same
but I'm not sure so I'd like to use both in the formula if possible.

What I want to happen is this:
IF F2<40
or
IF L2 = 0 or "" or "TBD" AND X2< 60 (actually a formula I have for #
of working days between todays date and a need date)

I want to return X in the cell. If none of the above are true, just
leave the cell blank "".

Thanks.

Here's what I have come up with but it doesn't work.

=IF(OR(F2<40,(OR(L2=0,L2="",L2="TBD",AND((NETWORKDAYS(TODAY(),M2,Holiday!$A$3:$A$25))<60)))),"X","")

 

[aidan.heritage]

I think you've over complicated it


=IF(OR(F2<40,AND(DateTest,OR(L2=0,L2="",L2="TBD"))),"X","")

I've put in DateTest rather than typing your formula again, but this
SHOULD do what you want!

 

[Dav]

i have not counted the brackets but possibly

IF(OR(F2<40,(and(OR(L2=0,L2="",L2="TBD"),((NETWORKDAYS(TODAY(),M2,Holiday!$A$3:$A$25))<60)))),"X","")


Regards

Dav