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