If someone could point me in the best direction to go I would greatly appreciate it. Here is what I need;

A quantity will be entered in the cell by the user and from that 4 cells in another worksheet will be determined.

If Cell N2 in print.worksheet
>=2 and <= 8 Then
(template.worksheet) Cell L27 and L28 = 2 AND Cell N27 and N28 = 0/1
else If
>=9 and <=15 Then
(template.worksheet) Cell L27 and L28 = 3 AND Cell N27 and N28 = 0/1
else If...

This will go on for all the following;
2 0/1 2-8
3 0/1 9-15
5 0/1 16-25
8 0/1 26-50
13 0/1 51-90
20 0/1 91-150
32 0/1 151-280
50 1/2 281-500
80 1/2 501-1,200
125 2/3 1,201-3,200
200 3/4 3,201-10,000
315 5/6 10,001-35,000
500 7/8 35,001-150,000

So if the user enters 1248 in cell N2 in Print worksheet, then cells L27 and L28 will change to 125 and Cell N27 and N28 will change to 2/3 in the template worksheet.

What would be the best way to approach this? Any help would be appreciated!