If a user enters a number say 300 I want the cell in the next column to automatically show 0-300



If they enter 512 I want it to change to 301-600 etc etc...

Is this possible?

Hi
your first interval 0-300 is not consistent with the second example.
It is 301 numbers long and 301-600 is 300 numbers long
If we discard 0 to make things consistent try

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks Pecoflyer but I didn't explain myself. I'm actually looking some data validation on the amount entered.

Basically I need numbers entered categorised into bands. So if people type in a number between 0 and 300 say I want in the next column text to appear as 0-300 if they type in 345 I want 301-600 to appear - this is so that when I do a pivot I can show the total of 0-300

I know I could do this in pivot tables but I need specific bands to appear not automated ones based on the range of results.

And is that not what my suggestion achieves ? ( except for 0?)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It works great - I need more coffee!!! Thank you for your help.