Elevation A | Elevation B | Elevation C | Elevation D |
24 | 32 | 31 | 35 |
15 | 20 | 25 | 30 |
<tbody>
</tbody>
I have two ranges of elevations (Elevation A and B and Elevation C and D) and I need a formula to determine if the two sets overlap. For example, Elevation A starts at 24 and ends at 32 and Elevation C starts at 31 and ends at 25. For this example, there is an overlap (31 and 32). In the third row of the above table, Elevation A starts at 15 and ends at 20, while Elevation C starts at 25 and ends at 30, so there is no overlap.
I am hoping that someone can help me with a formula to simply return a "yes" or "no" answer depending on whether the data ranges intersect.
Thanks in advance!!