Really stuck on an IF statement! Please help!!

Basically, I have 8 cells with different numbers in and I have to categorise them into groups. The numbers are 25, 45, 120, 140, 240, 63, 49 and 48. These numbers run from cell K3 to K10.

The groups are that these numbers have to fit in are the following: under 50, 50-99, 100-149, 150-199, 200+.

With these numbers I have them arranged like this: F3=0, F4=50. G3=50, G4=99. H3=100, H4=149. I3=150, I4=199, J3=200.

If one of the numbers at the top fit in the first category, then the cell with the IF statement must show 0.08. For the second category it must show 0.075, then 0.07, then 0.065 and finally 0.06.

I understand how to use (for example) $A$1 signs so that when I enter the IF function it doesn't change them all when I drag the cell down for the statement to apply to all the 8 cells.


Does anybody know what I need to do? Thanks!