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

Try creating a lookup table and returning the range value from the
lookup table


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399860