how to return a certain value if a number is within a range
A simple VLOOKUP should do the trick
Col A Col B
0 1
5 2
10 3
etc.
85 10
100 -1 (-1 to signify error)
=VLOOKUP(A1,$B$1:$B$B11,2)
George
Caconz wrote:
"Peo Sjoblom" wrote:
What about defects between 0-20 and 30-80?
Portland, Oregon
Well, yes, they would all have to have results as well, but I was just
looking for a start on the formula.
The total accurate list would be 0-5 = 1, 5-10 = 2, 10-15 = 3, 15-20 = 4,
20-25 = 5, 25-30 = 6, 30-50 = 7, 50-70 = 8, 70-85 = 9, 85-100 = 10
Any ideas?
|