Excel - How to make a certain value set of numbers return different text values in another cell
<p>I am trying to make a certain cell in excel make another cell in excel say something specific. Example using cells J15 and J16:</p>

<p>If cell J15 has a number value greater than or equal to 1 but less than 2, then I want cell J16 to read Unsatisfactory.</p>

<p>If cell J15 has a number value greater than or equal to 2 but less than 3, then I want cell J16 to read Needs Improvement.</p>

<p>If cell J15 has a number value greater than or equal to 3 but less than 4 . I want then Cell J16 to read Meets Expectations. </p>

<p>If cell J15 has a number value greater than or equal to 4 but less than 5, then I want cell J16 to read Exceeds Expectations. </p>

<p>If cell J15 has a number value greater than or equal to 5, then I want cell J16 to read Exceptional.</p>

<p>So basically depending on the number in cell J15, I need cell J16 to either read, Unsatisfactory, Needs Improvement, Meets Expectations, Exceeds Expectations, or Exceptional. </p>