HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?

[TEJAS SHAH]

I WANT TO CREATE THE PRICE RANGE IN EXCEL 2003 WITHOUT USING THE "IF ELSE"
COMBINATION.

SR PRICE RANGE
1 1500
2 3500
3 4750
4 6000
5 750
6 10000

RANGE SHOULD BE 0-1000, 1001-3000, 3001-5000, 5001- 7500, 7501-10000.

THANKS

 

[TEJAS SHAH]

Formula is better option. if Price is 1500 the range will be 1001-3000.

 

[Jacob Skaria]

Hi Tejas

You can use LOOKUP. Assuming your price is in Col B try the below formula in
C2 and copy down as required..Try and feedback

=LOOKUP(B2,{0,1,1001,3001,5001,7501},{"","0-1000","1001-3000","3001-5000","5001- 7500","7501-10000"})

If this post helps click Yes