Hi,

I need to create a formula the will give the following results:
IF B8 is between 1 and 5000 the result is 1, if B8 is between 5001 and 10000
the result is 2 and so on.

Any help would be appreciated.

Many thanks

Charlie