In E2, =INT(D2/500)*500&"-"&INT(D2/500)*500+499 will return the eg 1500-1999
for any value between in this range.

--
Ian
--
"KDD" wrote in message
...
Ian,

My D column in the database has values ranging from 500 to 75000. I want
to
E to return these values by putting them in pre-defined bins (ranges) of
500-999, 1000-1499, 1500-1999 etc.
--
KDDXB


"Ian" wrote:

Not sure what you want here. Do you want to count the number of times
values
within a range occur?

--
Ian
--
"KDD" wrote in message
...
I would like to slot cell values starting from 500 upto 75000 in ranges
(bins) like 500-999, 1000-1499, 1500to 1999 etc. How do i do this? I
have
15
bins.

pls help