problem for grouping data

[atulvw]

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.

[blobbles]

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

[atulvw]

Thank you Sir

[Cutter]

Possibly this:

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

[Kevin UK]

Hi atulvw

Another version:

Please Login or Register  to view this content.