On Sun, 28 Aug 2005 07:54:02 -0700, KDD <KDD@discussions.microsoft.com> 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