|There are 2 problems with the construction of your If statement.|
First, the syntax of an IF statement is:
IF(logical_test, value_if_true, value_if_false)
So, when writing a Nested IF such as yours, the second IF has to be the value_if_false for the first IF since the second IF is what you want Excel to look at if the value of the first IF is FALSE, and so on.
As an example,
Second, if you want to check if a value is between 2 numbers, you have to use an AND statement to get a TRUE or FALSE.
=AND(A1>=1,A1<=10) will be TRUE for values from 1 to 10.
So combining both of those concepts we get:
Hope that helps.