Formula Help - Urgent

[pip_kay]

Hey Guys,
I had help writing this formula yesterday and now need to extend it.

The basis of what I am trying to achieve is as follows:

If the value of Column X is between 1 and 8, then mark the corresponding cell in AB as 1 but if the value of Column X is between 8 and 16 mark the cell in AB as 2 but if the value of Column X is between 16 and 24 mark the column in AB as 3.

What is the formula I would need to put in to AB to make this happen?

Image attached.

Thanks guys! really appreciate any help on this.Screen Shot 2016-06-01 at 9.00.24 am.png

[spitfireblue]

Hi pip_kay,

Try this:

=IF(X3<=8,1,IF(X3<=16,2,IF(X3<=24,3)))

[Pete_UK]

I can't view your screenshot, but assuming the data starts in row 2, put this formula in AB2:

=IF(X2<=0,"",INT((X2-1)/8)+1)

then copy down.

Hope this helps.

Pete

[pip_kay]

Stephen, you are BRILLIANT!
Thank you! that worked perfectly!

Cheers,
Pip