HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?
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 |
HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?
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 |
HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?
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 |
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 |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com