title: Why isn't Importrange() data working in function?
body: <p>I've looked up every solution to this question and tried them all with no luck.</p>
  <p>Im importing coordinates from another page and determining if they're between a range using the =if(and() function. But it seems like the and() will only accept 3 and() statements max. And some of the functions don't even register in the functions. I cant figure out why.</p>
  <p>All cells are formatted as numbers
  tried various combinations</p>
  <p>Feel free to play with the function. I've been working on it for 3 days and still can't find a solution. Can anyone help?</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1OZSDju3hRyGyRfFhHJT2PLQ3DBvcfOAT1ZvNxB-J0DQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1OZSDju3hRyGyRfFhHJT2PLQ3DBvcfOAT1ZvNxB-J0DQ/edit?usp=sharing</a></p>
  <p>Take a look at the green higlighted rows. They all fall within the Green highlights range but nothing.,,</p>