Why isn't Importrange() data working in function?

I've looked up every solution to this question and tried them all with no luck.

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.

All cells are formatted as numbers tried various combinations

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?

https://docs.google.com/spreadsheets/d/1OZSDju3hRyGyRfFhHJT2PLQ3DBvcfOAT1ZvNxB-J0DQ/edit?usp=sharing

Take a look at the green higlighted rows. They all fall within the Green highlights range but nothing.,,