title: How to use a due date and task progress to create an overall status?
body: <p>I have an Excel sheet with due dates in column B and task progress (% complete) in column C.</p>
  
  <pre><code>Column A    Column B       Column C           Column D
  Task ID     Due Date       Task Complete      Status
  
  001         10/1/2018      90%
  002         10/1/2018      25%
  003         10/22/2018     75%
  004         10/22/2018     50%
  005         10/31/2018     0%
  </code></pre>
  
  <p>based off of that data I would like to use column D to insert the overall status based on some defined scoring:</p>
  
  <ul>
  <li>90% and within one week of due date = On Track</li>
  <li>75% - 89% and within one week of due date = At Risk</li>
  <li>74% - 50% and within one week of due date = Off Schedule</li>
  <li>49% - 0% and within one week of due date = In trouble</li>
  </ul>
  
  <p>Is it possible to use a formula for this?</p>