Link to home
Start Free TrialLog in
Avatar of Europa MacDonald
Europa MacDonaldFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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 ?
Avatar of loopfinity
loopfinity

Avatar of Patrick Matthews
Are you basically trying to see how many thousands there are?  If so:

=INT(A3/1000)
Avatar of Europa MacDonald

ASKER

sorry , doesnt mean much to me
no sorry, not thousands, that was just an example
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 https://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