Thread: Combining two AND functions into an OR function

Hi everyone!

So here's what I got:

=IF(ISNUMBER(SEARCH("U",$G3)),IF(AND(S$2>=$H3,S$2<$I3),"x",""),"")
=IF(ISNUMBER(SEARCH("U",$J3)),IF(AND(S$2>=$K3,S$2<$L3),"x",""),"")

I'm currently using these two IF functions and I want to combine then into one formula that make it so if one of these two conditions is true it puts an x in the cell. I've been messing with this for hours and can't seem to get it to work!

Eventually I would like to use three of these functions. Unfortunately I'm very new to this and am struggling to figure it out. Thanks for any help.

edit: To be more clear it's the text in green that i want to be OR'd to give the result of:
If one is true "x"
If false " "

How about?

=IF(OR(AND(ISNUMBER(SEARCH("U",$G3)),S$2>=$H3,S$2<$I3),AND(ISNUMBER(SEARCH("U",$J3)),S$2>=$K3,S$2<$L 3)),"x","")

!! Thanks for the help! This is great!

I'm having one small issue with the formula though. I am using this new formula and now certain times are being pushed forward by a half an hour from how I had it in the formulas I gave. I don't see what changed in this new formula that would be causing this.

Disregard..

Thanks so much! I wish i could hug you right now!

The formula checks if either of these combinations of 3 criteria are TRUE or FALES

ISNUMBER(SEARCH("U",$G3)),S$2>=$H3,S$2<$I3

ISNUMBER(SEARCH("U",$J3)),S$2>=$K3,S$2<$L3

if either combination is true, then "x" is returned, else a blank.

Is that the correct logic?

Yup that's exactly what I'm going for. I'm still having a problem where it's pushing some back by 30 minutes, but i believe that may be an error on my end.

I have edited my original post with an attachment so you can see what I'm talking about.

If you look at the classes on Monday, they are all a half an hour pushed back than I want them to be.

I once again appreciate your help! Ty.

When comparing times, sometimes there are precision issues, based on how the times were achieved in the cells.... I usually round to 6 decimals to get accuracy...

so, for example, in BO3 for "M" try:

=IF(OR(AND(ISNUMBER(SEARCH("M",$G3)),ROUND(BO$2,6)>=ROUND($H3,6),ROUND(BO$2,6)<ROUND($I3,6)),AND(ISNUMBER(SEARCH("M",$J3)),ROUND(BO$2,6)>=ROUND($K3,6),ROUND(BO$2,6)<ROUND($L3,6))),"x","")