title: Formula to Show How Far Away a Number is From The Uppermost Value in a Range
body: <p>I thoroughly enjoy an Excel challenge, but have found myself stumped on this one and through sheer curiosity thought I'd put it out there for others to attempt.</p>
  
  <p>I have been challenged to think of a formula which shows how close three different values are from being classified as part of the next threshold in the sample data below.</p>
  
  <pre><code>Values
  
  12458 (Okay)
  28451 (Good)
  54851 (Excellent)
  
  Threshold
  
  0        10000    Poor
  10000    20000    Okay
  20000    35000    Good
  35000    50000    Great
  50000             Excellent
  </code></pre>
  
  <p>What I need to do is think of a formula which will tell me how far away (if applicable) one particular value is from the next threshold.  How can I go about this?</p>