[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

[Simon Lloyd[_265_]]

Do you want this in VBA or formula? what do you want to show for the
range? i.e if the price is 1500 what would you want to display in the
range?

TEJAS SHAH;377263 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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105573

[TEJAS SHAH[_2_]]

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


"Simon Lloyd" wrote:


Do you want this in VBA or formula? what do you want to show for the
range? i.e if the price is 1500 what would you want to display in the
range?

TEJAS SHAH;377263 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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105573

[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
---------------
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