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

*To*: mathgroup at smc.vnet.net*Subject*: [mg55271] Multiple > and < calculations [great than & less than]*From*: "Geezer" <clive at gemnet.co.uk>*Date*: Fri, 18 Mar 2005 05:33:47 -0500 (EST)*Sender*: owner-wri-mathgroup at wolfram.com

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

**Follow-Ups**:**Re: Multiple > and < calculations [great than & less than]***From:*Daniel Lichtblau <danl@wolfram.com>