Can AND functions be nested within nested IF functions?

I have been able to next IF functions but am having trouble including what I think needs to be a nested AND function. I have attached a worksheet...I need the value in column C to be based on data in columns A and B. But in the table that determines the ranges, getting a formula for the range of 1000-1500 is giving me trouble because it seems like it should be a nested AND function. But it doesn't work. Any help would be great! Thanks!