|There are two issues with your question:|
First, your Nested IF:
The first condition of this function checks B17, the rest check B1. You said:
Is the B17 a typo or is B17 < 10 actually the first (therefore the highest priority) condition to be checked?
and so on...
What does that mean?
Depending on how many conditions you have to check and depending on what version of Excel you are running, there are multiple ways to address your requirements.
Give us a little more detail and we can do a better job of helping you.
Make sure you include the Excel version you are running.
Posting Tip: Before posting Data or VBA Code, read this How-To.