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