how to determine the value of a cell

how do I write in formula
if A3 > 1000 < 2000 then this cell = 1
or if A3 >2000 < 3000 then this cell = 2
or if A3 >3000 <4000 then this cell = 3 etc ?
Europa MacDonaldChief slayer of dragonsAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
Something like this:

=CHOOSE(MATCH(A1,{0,1000,2000,3000},1),0,1,2,3)

Kevin
0
 
Patrick MatthewsCommented:
Are you basically trying to see how many thousands there are?  If so:

=INT(A3/1000)
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
sorry , doesnt mean much to me
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
no sorry, not thousands, that was just an example
0
 
Patrick MatthewsCommented:
Well, you could use nested IF statements, but I find those difficult to read and understand.  You could use VLOOKUP.

If you put these values into, say, A1:B10 on a worksheet named Lookup:

Start At      Value
-1.00E+99      N/A
1000      1
2000      2
3000      3
4000      4
5000      5
6000      6
7000      7
8000      N/A

You could then use a formula like this to retrieve the reported values:

=VLOOKUP(A2,Lookup!$A$2:$B$10,2)

See this file for an example of the above:

Q-26929659.xls

For more info on VLOOKUP, please see my article http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2637-Six-Reasons-Why-Your-VLOOKUP-or-HLOOKUP-Formula-Does-Not-Work.html

Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.