Re: Multiple > and < calculations [great than & less than]

*To*: mathgroup at smc.vnet.net*Subject*: [mg55320] Re: [mg55271] Multiple > and < calculations [great than & less than]*From*: Mitch.Stonehocker at sungard.com*Date*: Sat, 19 Mar 2005 04:45:23 -0500 (EST)*Sender*: owner-wri-mathgroup at wolfram.com

In[8]:= bins={{{0,999},"nothing"}, {{1000,1500},"A"}, {{1501,2500},"B"}, {{2501,Infinity},"C"}}; In[10]:= number=2800;Select[bins,#[[1,1]]?number?#[[1,2]]&] Cheers, Mitch Stonehocker -----Original Message----- From: Geezer [mailto:clive at gemnet.co.uk] To: mathgroup at smc.vnet.net Subject: [mg55320] [mg55271] Multiple > and < calculations [great than & less than] USING EXCEL I need a simple formula.............. I want to give a set value to a number within a given range e.g cell value is 1038 - the look up range is below - so the formula should return the value 'A' - because the example cell value is between 1000 and 1500 Value Range Result <999 1000-1500 A 1501-2500 B 2501-3500 C 3501-4500 D 4501-5500 E 5501-7000 F 7001-10000 G 10001-15000 H 15001-20000 I 20001-30000 J >30001 K There are over 10,000 cells to run the formula through Help Please you can reply directly if you wish Many Thanks G