Thread: HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TEJAS SHAH TEJAS SHAH is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote