Using If/Then/Else statements with ranges of data

Hello!
Let me start off by saying I'm an excel newbie (I just started using formulas today).
However, I have a rather complex task I'm trying to accomplish. I have almost no knowledge of excel formulas/coding so I'll try to explain in just words.

I have several ranges of data and I would like to see if any values of this range overlap with another range.

Say column A is the lower limit of one range, B is the upper limit. Column C is the lower limit of a second range, D is the upper limit, etc.

I'm wanting to check if any of these ranges (A to B, or C to D, etc) completely or partially overlap with the range 30<x<=60.

I would like to get a "1" in the cell if there is any overlap and a "0" if there is none.

I'm guessing the code/formula would have to say something like this (please forgive me for not putting this in proper excel language):

If A<=x<=B overlaps with 30<x<=60 then cell = 1
else if C<=x<=D overlaps with 30<x<=60 then cell = 1
else cell = 0

I'm not even sure if this is possible.

Thank you so much!

Sorry, how do I post a sample workbook?

I did some googling and found an "intersect" function which looks like it could determine if ranges overlap. I'm not sure how it to use it though.
http://www.ozgrid.com/VBA/vba-intersect.htm
I'm not sure if this is the right thing.

I was also wondering how does VB relate to excel? I once used VB ages ago. Would I need it to do this excel function or can I just use excel?

I tried to make a simplied example of what I want. Let me know if this helps!

I'm wanting to check if any of these ranges (A to B, or C to D, etc) completely or partially overlap with the range 30<x<=60.

Try the formula below

Please Login or Register  to view this content.

This will return "1" if either A to B or C to D (or both) overlap with 30<x<=60. However your example shows "0" when C to D is 25 to 40 which surely does overlap and so should be "1" as given by the formula.