# 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 ?
###### Who is Participating?

ConsultantCommented:
Something like this:

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

Kevin
0

Commented:
Are you basically trying to see how many thousands there are?  If so:

=INT(A3/1000)
0

Chief slayer of dragonsAuthor Commented:
sorry , doesnt mean much to me
0

Chief slayer of dragonsAuthor Commented:
no sorry, not thousands, that was just an example
0

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

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.