An Excel Question on If Statements Or something else.?
I have a situation where I have two columns of data Column A is from a result from a formula (We will call the location B11).
Now, the data unfortunately has 15 results. An IF statement can only go up to 7. And I cannot use VLOOKUP as I have to get the data to get greater than or equal to column A If my greater than or equal to euals the data then similar to VLOOKUP, it will slide over to get the value I want returned.
Here is the columns:
101 70
91 60
81 50
71 45
61 40
50 35
45 28
40 25
35 22
30 19
25 16
20 13
15 11
10 8
5 5
Two examples:
If my number is 104, I would like Excel to return 70 (From Col 2)
If my number is 76, I would like Excel to return 45 (Again, From Col. 2)
Oh, one more:
If my number is 40, I would like Excel to return 25 (Col 2 Result).
I really wish my Excel skills were as good as my Autocad Skills. I would not be asking this question.
As always, your help in this will be greatly appreciated.