=IF(AND(F2>=2,F2<=15),"2",IF(AND(F2>=16,F2<=25),"3",IF(AND(F2>=26,F2<=90),"5",IF(AND(F2>=91,F2<=150),"8",IF(AND(F2>=151,F2<=500),"13",IF(AND(F2>=501,F2<=1200)"20","IDK")))))) I am not sure why Excel wont accept this compound IF statement... help...
Solved by I. J. in 25 mins