between IF functions

In the worksheet i made, cell B10 looks at the chart to the right and either says it's high, low, or one of the exact values. But what i would like to do is have it also look at the numbers in between each value. So the program can find x and z (exact values from the chart) but it can't find x<y<z (in between numbers).
So how can i get that work. And if anybody can improve anything, that would be helpful too.

FYI it's protected, so you'll just have to unprotect it, and i have some of the math whited out on the right, so just make the text black again to see that stuff.