Cheers Pete, that's a start but I should have been more specific:

If value in cell X is 16 or less, I want cell Y to show value "1" AND if
value in cell X is more than 16, but less than or equal to 32, I want cell Y
to show value "2"
AND if value in cell X is more than 32, but less than or equal to 48, I want
cell Y to show value "3", and so on...

(Cell X being the same cell on the same spreadsheet all the way through)

Does this clarify?

"Pete_UK" wrote:

Here's one way of doing it:

=INT(CEILING(X,16)/16)

Put the formula in your Y cell, changing X to an appropriate cell
reference.

Hope this helps.

Pete


On Dec 5, 7:15 pm, TomL77 wrote:
Excel 2003

I want a cell to show a different value depending on whether another cell
shows less than, equal to, or more than a range of values. For example:

If value in cell X is 16 or less, I want cell Y to show 1
If value in cell X is more than 16, but less than or equal to 32, I want
cell Y to show 2
If value in cell X is more than 32, but less than or equal to 48, I want
cell Y to show 3
And so on...
Help please, can't seem to create the right syntax to make this happen...
Thanks