Failing with formula
Hi,
Thanks, that worked a treat :)
Charlie
"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
|