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