title: Return a number and text string in Excel If statement
body: <p>I am trying to create an If statement in Excel that calculates the difference between two dates (in this case "Required Submission Date" and "Actual Submission Date"), and then outputs the absolute value of this number and follows it with "Days overdue" or "Days until due" accordingly. </p>
  
  <p>I have attempted converting the number to a text string after the calculation:</p>
  
  <pre><code>=IF((H11-J11)&lt;0,TEXT(H11-J11,0)"Days overdue", TEXT(H11-TODAY(),0)"Days Until Due")
  </code></pre>
  
  <p>I have also attempted this:</p>
  
  <pre><code>=IF((H11-J11)&lt;0,abs(H11-J11)"Days overdue", (abs(H11-TODAY()))"Days Until Due")
  </code></pre>
  
  <p>Is there any way to achieve what I am after? i.e. if the submission is overdue, it should return "XX days overdue"</p>
  
  <p>Thanks</p>