Nice :-)

Wasn't sure if the 'and so on' was 5000 increments.

"Per Jessen" wrote:

Hi Charlie

Try his formula:

=ROUNDUP(B8/5000,0)

Regards,
Per

"Charlie" skrev i meddelelsen
...
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