title: Need help converting a range of numbers to text in excel
body: <p>I'm using MS Excel 2010; I'm a total newbie to using functions, so be kind when answering.</p>
  
  <p>I'm creating a sports grading sheet that will help instructors calculate the test scores for their students. So far I've set up excel to add a students individual points in a column and then give a percentage value out of 100%</p>
  
  <p>What I want to do now is have the percentage value be converted to a selection of text result. For example,  if a student gets 76.76% on their test; then their mark is considered a 'conditional pass' as it falls between the ranges of 75%-85%</p>
  
  <p>I need excel to determine which range their test results fall under and then automatically enter the text result in the cell underneath, e.g.:</p>
  
  <p><strong>Name:</strong> Student
   <strong>Percentage total</strong>: 76.76%
   <strong>Result:</strong> Conditional Pass              </p>
  
  <p>I'm going to have to assign every possible number (including decimal points) to one of three text results. </p>
  
  <p>Hope this makes some sense. 
  Thanks!</p>