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

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
ConsultantCommented:
Something like this:

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

Kevin
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

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