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