Europa MacDonald
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 ?
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 ?
Are you basically trying to see how many thousands there are? If so:
=INT(A3/1000)
=INT(A3/1000)
ASKER
sorry , doesnt mean much to me
ASKER
no sorry, not thousands, that was just an example
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=225
http://www.officearticles.com/excel/if_statements_in_formulas_in_microsoft_excel.htm ( using and/or)