problem for grouping data

Excel formula for cell G20 where it will return 14.5 if the number in cell I2 is 20-39, 14 if the number is 40-59, 13.5 if the number is 60-79, 13 if the number is 80-99, and 12.5 if the number is 100 or greater.

=IF(AND(I2>=20,I2<40),14.5,IF(AND(I2>=40,I2<50),14,IF(AND...))) etc

Thank you Sir

Possibly this:

=15-0.5*MIN(5,INT(I2/20))

Hi atulvw

Another version:

Formula:

=LOOKUP(I2,{0,20,40,60,80,100},{0,14.5,14,13.5,13,12.5})