Is A1 found between values B and C, where B is the start number and C is the end number, regardless of row? Excel <p>Is A1 found between values B and C, where B is the start number and C is the end number, regardless of row? In excel. </p> <p><a href="https://i.stack.imgur.com/N547W.png" rel="nofollow noreferrer">screenshot</a></p> <p><a href="https://i.stack.imgur.com/N547W.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N547W.png" alt="enter image description here"></a></p> <p>I am trying to figure if the transcription start site coordinate in A, is found within a gene (start coordinate is in B and end coordinate is in C). If so, write "yes", if not, write "no".</p>