Services & Resources / Wolfram Forums
MathGroup Archive
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2005

[Date Index] [Thread Index] [Author Index]

Search the Archive

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

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




Mitch Stonehocker

-----Original Message-----
From: Geezer [mailto:clive at]
To: mathgroup at
Subject: [mg55320] [mg55271] Multiple > and < calculations [great than & less

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
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

  • Prev by Date: Re: Distance from point to set
  • Next by Date: Re: Wolfram plugin for Google Desktop Search
  • Previous by thread: Re: Multiple > and < calculations [great than & less than]
  • Next by thread: nonLinearFit and nonLinearRegress