IF/AND/OR Help

D

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","")
 
A

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!
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top