title: Excel Formula to add text/word to a percentage result
body: <p>I have a formula in 1 cell</p>
  
  <pre><code>=(A6-B6)/B6
  </code></pre>
  
  <p>Which results to <code>-0.105243123560658</code>in cell C6. A6 has the new sales amount and B6 has the old sales amount. I'm trying to get the result formatted like:</p>
  
  <p><code>Difference is 10%</code></p>
  
  <p>I have 2 problems</p>
  
  <ul>
  <li>How to get the decimals turn into non-decimal number (I'm already researching on this)</li>
  <li>How to add a text/word to a calculation result like adding <code>"Difference is "</code> to the <code>(A6-B6)/B6</code> calculation result. </li>
  </ul>
  
  <p>This I have tried to research and the only solution I can find involves using additional cells. Is there a way to do this with using only 1 cell ($C$6)? I tried </p>
  
  <pre><code>="Difference is "&amp;(A6-B6)/B6
  </code></pre>
  
  <p>but I'm getting <code>Difference is -0.105243123560658</code> instead. Also tried:</p>
  
  <pre><code>="Difference is "&amp;($B$6-$C$6)/ABS($C$6)
  </code></pre>