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
- 6138 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago