HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?
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
---------------
Jacob Skaria
"TEJAS SHAH" wrote:
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
|