Thanks Ron.

Need some more clarity..

VLOOKUP does not seem to recognize "500-599" as a number and therefore is
not co-relating "500-599" with median as 750.
--
KDDXB


"Ron Rosenfeld" wrote:

On Sun, 28 Aug 2005 07:54:02 -0700, KDD wrote:

Hi.

Column G is a value from 500-75000 and i need to slot the value into 15
ranges like 500-999, 1000-1499 etc

How do i tackle this, as IF accepts nested command for only upto 7 scenarios??

pls help, thanks
KDDXB


Use VLOOKUP (see HELP for details):

=VLOOKUP(G1,{500,"500-999";1000,"1000-1499";1500,"1500-4999";5000,"5000-75000"},2)

The array is most easily listed in a table, with column 1 being your "break
points" and column 2 being how you want to identify the bins (ranges).


--ron