neyney0404's blog
Formula Help!!!!!!
Submitted by neyney0404 on 27 June, 2012 - 15:28I am struggling to find a formula that can lookup a range of numbers and autopopulate the correct answer.
For Example:
If someone has a rate between 67% and 69% they reeive a score of 24. I need to be able to enter 68% in a cell and have a formula that knows 68% is in between 67% and 69%.
Currently my data table is set up with 67% in cell B5, 69% in cell C5 and the score of 24 in cell D5. Do I need to set it up differently? Please help.
I have attached an example. THe PIR tab is where I inout data and the legend is where I need to pull it from
»
- 4 comments
- 6148 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago