In cell AD17 type this formula and then copy it down to AD36:
=SI(L17<=1,5;5;SI(Y(L17>1,5;L17<=2,5);4;SI(Y(L17>2,5;L17<=4);3;SI(Y(L17>4;L17<=6);2;SI(Y(L17>6;L17<=9);1;0)))))

My excel program runs in Spanish, if yours run in English substitute "SI" for "IF" and "Y" for "AND". In this formula the "," is the decimal separator, if your decimal separator is the period (.) substitue "," for ".". I used this formula successfully in my Excel 2010 version.

Let me know how your program works! I once did a small excel spreadsheets that was very simple as it simply ranked the horsed according to their last speeds, and once it picked the 6 horses finishing in a race in the correct order!! but that proved to be an statistical anomaly... hehehe.

Best regards,