Cosine has it... I was about to write it, thx for getting me out of it.
You dont have to finish the IF statement there, for example =IF(AND(A1>1,A1<5),"Tier1",IF(AND(A1>5,A1<10),"Tier2",....
Where the function finishes and you can put the if true or false you can write another if statement...